{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["gl. til nyt niveau","reguleringsprocenter","Lønark","Forside","Omregner","Omregningstabel ","Tillæg_trin","Tillæg_kr","Samlet_omk","Tid op_ned"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":75,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"gl. til nyt niveau","index":0,"n_rows":395,"n_cols":6,"rows_kept":395,"cut":false,"hidden":true,"merged":[]}
[null,1.3980790000000001]
[null,null,null,"Nyt grundbeløb","Nyt grundbeløb"]
["Grundbeløb pr. 1/10-1984","I alt pr. 1. april 1999 inkl. %regulering",null,"pr. 31/3-2000","pr. 31/3-2000"]
[null,null,null,"ekskl. afrunding","inkl. afrunding"]
[null,null,null,null,null,"beløb"]
[null,"pr. gang/år","pr. måned",null,null,"+/-"]
[1.63,{"$f":"IF(A7<1000,$B$1*A7,ROUND($B$1*A7,0))","v":2.2788687699999999},null,{"$f":"B7","v":2.2788687699999999},{"$f":"IF(D7<1000,D7,ROUND(D7,-2))","v":2.2788687699999999}]
[5,6.9903950000000004,null,{"$f":"B8","v":6.9903950000000004},6.9903950000000004]
[5.8,8.1088582000000002,null,8.1088582000000002,8.1088582000000002]
[9,12.582711,null,12.582711,12.582711]
[10.5,14.6798295,null,14.6798295,14.6798295]
[12.22,17.084525380000002,null,17.084525380000002,17.084525380000002]
[12.65,17.68569935,null,17.68569935,17.68569935]
[13.39,18.720277810000002,null,18.720277810000002,18.720277810000002]
[13.75,19.22358625,null,19.22358625,19.22358625]
[14.46,20.216222340000002,null,20.216222340000002,20.216222340000002]
[15.2,21.2508008,null,21.2508008,21.2508008]
[15.5,21.6702245,null,21.6702245,21.6702245]
[17,23.767343,null,23.767343,23.767343]
[18.5,25.864461500000001,null,25.864461500000001,25.864461500000001]
[19,26.563501000000002,null,26.563501000000002,26.563501000000002]
[21,29.359659000000001,null,29.359659000000001,29.359659000000001]
[23,32.155816999999999,null,32.155816999999999,32.155816999999999]
[24.97,34.910032630000003,null,34.910032630000003,34.910032630000003]
[28,39.146212000000006,null,39.146212000000006,39.146212000000006]
[30,41.942370000000004,null,41.942370000000004,41.942370000000004]
[33.29,46.542049910000003,null,46.542049910000003,46.542049910000003]
[42,58.719318000000001,null,58.719318000000001,58.719318000000001]
[61.26,85.646319540000007,null,85.646319540000007,85.646319540000007]
[62,86.680897999999999,null,86.680897999999999,86.680897999999999]
[68.319999999999993,95.516757279999993,null,95.516757279999993,95.516757279999993]
[75.13,105.03767526999999,null,105.03767526999999,105.03767526999999]
[80.38,112.37759002,null,112.37759002,112.37759002]
[136.63999999999999,191.03351455999999,null,{"$f":"B34","v":191.03351455999999},191.03351455999999]
[143.99,201.30939521000002,null,{"$f":"B35","v":201.30939521000002},201.30939521000002]
[150.61000000000001,210.56467819000002,null,210.56467819000002,210.56467819000002]
[164,229.28495600000002,null,229.28495600000002,229.28495600000002]
[170,237.67343000000002,null,237.67343000000002,237.67343000000002]
[190,265.63501000000002,null,265.63501000000002,{"$f":"IF(D39<1000,D39,ROUND(D39,-2))","v":265.63501000000002}]
[195,272.625405,null,272.625405,272.625405]
[202,282.41195800000003,null,282.41195800000003,282.41195800000003]
[260,363.50054,null,363.50054,363.50054]
[278,388.66596200000004,null,388.66596200000004,388.66596200000004]
[300.83999999999997,420.59808635999997,null,420.59808635999997,420.59808635999997]
[350,489.32765000000001,null,489.32765000000001,489.32765000000001]
[380,531.27002000000005,null,531.27002000000005,531.27002000000005]
[398.95,557.76361704999999,null,557.76361704999999,557.76361704999999]
[420,587.19317999999998,null,587.19317999999998,587.19317999999998]
[465,650.10673500000007,null,650.10673500000007,650.10673500000007]
[490,685.05871000000002,null,685.05871000000002,685.05871000000002]
[502,701.83565800000008,null,701.83565800000008,701.83565800000008]
[559,781.526161,null,781.526161,781.526161]
[597,834.65316300000006,null,834.65316300000006,834.65316300000006]
[700,978.65530000000001,{"$f":"VALUE(B54)/12","v":81.554608333333334},978.65530000000001,{"$f":"IF(D54<1000,D54,ROUND(D54,-2))","v":978.65530000000001},{"$f":"E54-D54","v":0}]
[750,1048.55925,87.379937499999997,1048.55925,{"$f":"IF(D55<1000,D55,ROUND(D55,-2))","v":1000},-48.55925000000002]
[800,1118.4632000000001,93.205266666666674,1118.4632000000001,{"$f":"IF(D56<1000,D56,ROUND(D56,-2))","v":1100},-18.463200000000143]
[842.75,1178.23107725,98.185923104166662,1178.23107725,1200,21.768922750000002]
[868,1213.5325720000001,101.12771433333334,1213.5325720000001,1200,-13.532572000000073]
[917.14,1282.23417406,106.85284783833333,{"$f":"B59","v":1282.23417406},1300,17.765825940000013]
[920,1286.2326800000001,107.18605666666667,1286.2326800000001,1300,13.767319999999927]
[925,1293.2230750000001,107.76858958333334,1293.2230750000001,1300,6.776924999999892]
[950,{"$f":"IF(A62<1000,$B$1*A62,ROUND($B$1*A62,0))","v":1328.1750500000001},110.68125416666668,1328.1750500000001,1300,-28.175050000000056]
[1000,{"$f":"IF(A63<1000,$B$1*A63,ROUND($B$1*A63,0))","v":1398},116.5,1398,1400,2]
[1050,{"$f":"IF(A64<1000,$B$1*A64,ROUND($B$1*A64,0))","v":1468},122.33333333333333,1468,1500,32]
[1100,{"$f":"IF(A65<1000,$B$1*A65,ROUND($B$1*A65,0))","v":1538},128.16666666666666,1538,1500,-38]
[1200,1678,139.83333333333334,1678,1700,22]
[1245,1741,145.08333333333334,{"$f":"B67","v":1741},1700,{"$f":"E67-D67","v":-41}]
[1300,1818,151.5,1818,1800,-18]
[1327,1855,154.58333333333334,1855,1900,45]
[1400,1957,163.08333333333334,1957,2000,43]
[1500,2097,174.75,2097,2100,3]
[1600,2237,186.41666666666666,2237,2200,-37]
[1700,2377,198.08333333333334,2377,2400,23]
[1750,2447,203.91666666666666,2447,2400,-47]
[1800,2517,209.75,2517,2500,-17]
[1900,2656,221.33333333333334,2656,2700,44]
[2000,2796,233,2796,2800,4]
[2050,2866,238.83333333333334,2866,2900,34]
[2100,2936,244.66666666666666,2936,2900,-36]
[2145,2999,249.91666666666666,2999,3000,1]
[2150,3006,250.5,3006,3000,-6]
[2200,3076,256.33333333333331,3076,3100,24]
[2300,3216,268,3216,3200,-16]
[2400,3355,279.58333333333331,3355,3400,45]
[2450,3425,285.41666666666669,3425,3400,-25]
[2500,3495,291.25,3495,3500,5]
[2600,3635,302.91666666666669,3635,3600,-35]
[2700,3775,314.58333333333331,3775,3800,25]
[2730,3817,318.08333333333331,3817,3800,-17]
[2800,3915,326.25,3915,3900,-15]
[2900,4054,337.83333333333331,4054,4100,46]
[3000,4194,349.5,4194,4200,6]
[3100,4334,361.16666666666669,4334,4300,-34]
[3200,4474,372.83333333333331,4474,4500,26]
[3300,4614,384.5,4614,4600,-14]
[3400,4753,396.08333333333331,4753,4800,47]
[3500,4893,407.75,4893,4900,7]
[3600,5033,419.41666666666669,5033,5000,-33]
[3700,5173,431.08333333333331,5173,5200,27]
[3800,5313,442.75,5313,5300,-13]
[3900,5453,454.41666666666669,5453,5500,47]
[4000,5592,466,5592,5600,8]
[4100,5732,477.66666666666669,5732,5700,-32]
[4200,5872,489.33333333333331,5872,5900,28]
[4226.1000000000004,5908,492.33333333333331,5908,5900,-8]
[4300,6012,501,6012,6000,-12]
[4400,6152,512.66666666666663,6152,6200,48]
[4430,6193,516.08333333333337,6193,6200,7]
[4500,6291,524.25,6291,6300,9]
[4600,6431,535.91666666666663,6431,6400,-31]
[4700,6571,547.58333333333337,6571,6600,29]
[1770,2475,206.25,2475,2500,25]
[4800,6711,559.25,6711,6700,-11]
[4900,6851,570.91666666666663,6851,6900,49]
[4930,6893,574.41666666666663,6893,6900,7]
[5000,6990,582.5,6990,7000,10]
[5100,7130,594.16666666666663,7130,7100,-30]
[5200,7270,{"$f":"VALUE(B118)/12","v":605.83333333333337},7270,7300,30]
[5300,7410,617.5,7410,7400,-10]
[5318,7435,619.58333333333337,7435,{"$f":"IF(D120<1000,D120,ROUND(D120,-2))","v":7400},-35]
[5400,7550,629.16666666666663,7550,7600,50]
[5420.91,7579,631.58333333333337,7579,7600,21]
[5500,7689,640.75,{"$f":"B123","v":7689},7700,{"$f":"E123-D123","v":11}]
[5600,7829,652.41666666666663,7829,7800,-29]
[5700,7969,664.08333333333337,7969,8000,31]
[5770.78,8068,672.33333333333337,8068,8100,32]
[5800,8109,675.75,8109,8100,-9]
[5900,8249,687.41666666666663,8249,8200,-49]
[6000,{"$f":"IF(A129<1000,$B$1*A129,ROUND($B$1*A129,0))","v":8388},699,8388,8400,12]
[6078,8498,708.16666666666663,8498,8500,2]
[6100,8528,710.66666666666663,8528,8500,-28]
[6140,8584,715.33333333333337,8584,8600,16]
[6200,8668,722.33333333333337,8668,8700,32]
[6290.15,8794,732.83333333333337,8794,8800,6]
[6300,8808,734,8808,8800,-8]
[6400,8948,745.66666666666663,8948,8900,-48]
[6500,9088,757.33333333333337,9088,9100,12]
[6600,9227,768.91666666666663,9227,9200,-27]
[6700,9367,780.58333333333337,9367,9400,33]
[6743.33,9428,785.66666666666663,9428,9400,-28]
[6800,9507,792.25,9507,9500,-7]
[6900,9647,803.91666666666663,9647,9600,-47]
[7000,9787,815.58333333333337,9787,9800,13]
[7100,9926,827.16666666666663,9926,9900,-26]
[7200,10066,838.83333333333337,10066,10100,34]
[7300,10206,850.5,10206,10200,-6]
[7335.23,10255,854.58333333333337,10255,10300,45]
[7400,10346,862.16666666666663,10346,10300,-46]
[7500,10486,873.83333333333337,10486,10500,14]
[7600,10625,885.41666666666663,10625,10600,-25]
[7700,10765,897.08333333333337,10765,10800,35]
[7800,10905,908.75,10905,10900,-5]
[7900,11045,920.41666666666663,11045,11000,-45]
[8000,11185,932.08333333333337,11185,11200,15]
[8100,11324,943.66666666666663,11324,11300,-24]
[8200,11464,955.33333333333337,11464,11500,36]
[8300,11604,967,11604,11600,-4]
[8400,11744,978.66666666666663,11744,11700,-44]
[8500,11884,990.33333333333337,11884,11900,16]
[8600,12023,1001.9166666666666,12023,12000,-23]
[8700,12163,1013.5833333333334,12163,12200,37]
[8800,12303,1025.25,12303,12300,-3]
[8900,12443,1036.9166666666667,12443,12400,-43]
[9000,12583,1048.5833333333333,12583,12600,17]
[9100,12723,1060.25,12723,12700,-23]
[9200,12862,1071.8333333333333,12862,12900,38]
[9300,13002,1083.5,13002,13000,-2]
[9400,13142,1095.1666666666667,13142,13100,-42]
[9450,13212,1101,13212,13200,-12]
[9500,13282,1106.8333333333333,13282,13300,18]
[9600,13422,1118.5,13422,13400,-22]
[9700,13561,1130.0833333333333,13561,13600,39]
[9800,13701,1141.75,13701,13700,-1]
[9900,13841,1153.4166666666667,13841,13800,-41]
[10000,13981,1165.0833333333333,13981,14000,19]
[10600,14820,1235,14820,14800,-20]
[10800,15099,1258.25,15099,15100,1]
[11000,15379,1281.5833333333333,15379,15400,21]
[11200,15658,1304.8333333333333,15658,15700,42]
[11300,15798,1316.5,15798,15800,2]
[11500,16078,1339.8333333333333,16078,16100,22]
[11600,16218,{"$f":"VALUE(B182)/12","v":1351.5},16218,16200,-18]
[11700,16358,1363.1666666666667,16358,16400,42]
[11800,16497,1374.75,16497,{"$f":"IF(D184<1000,D184,ROUND(D184,-2))","v":16500},3]
[11900,16637,1386.4166666666667,16637,16600,-37]
[12000,16777,1398.0833333333333,16777,16800,23]
[12100,16917,1409.75,{"$f":"B187","v":16917},16900,{"$f":"E187-D187","v":-17}]
[12200,17057,1421.4166666666667,17057,17100,43]
[12300,17196,1433,17196,17200,4]
[12400,17336,1444.6666666666667,17336,17300,-36]
[12500,17476,1456.3333333333333,17476,17500,24]
[12600,17616,1468,17616,17600,-16]
[12700,{"$f":"IF(A193<1000,$B$1*A193,ROUND($B$1*A193,0))","v":17756},1479.6666666666667,17756,17800,44]
[12800,17895,1491.25,17895,17900,5]
[12900,18035,1502.9166666666667,18035,18000,-35]
[13000,18175,1514.5833333333333,18175,18200,25]
[13200,18455,1537.9166666666667,18455,18500,45]
[13400,18734,1561.1666666666667,18734,18700,-34]
[13500,18874,1572.8333333333333,18874,18900,26]
[13700,19154,1596.1666666666667,19154,19200,46]
[14000,19573,1631.0833333333333,19573,19600,27]
[14300,19993,1666.0833333333333,19993,20000,7]
[14500,20272,1689.3333333333333,20272,20300,28]
[14700,20552,1712.6666666666667,20552,20600,48]
[14800,20692,1724.3333333333333,20692,20700,8]
[14900,20831,1735.9166666666667,20831,20800,-31]
[15000,20971,1747.5833333333333,20971,21000,29]
[15100,21111,1759.25,21111,21100,-11]
[15200,21251,1770.9166666666667,21251,21300,49]
[15500,21670,1805.8333333333333,21670,21700,30]
[15700,21950,1829.1666666666667,21950,22000,50]
[15900,22229,1852.4166666666667,22229,22200,-29]
[16000,22369,1864.0833333333333,22369,22400,31]
[16100,22509,1875.75,22509,22500,-9]
[16200,22649,1887.4166666666667,22649,22600,-49]
[16700,23348,1945.6666666666667,23348,23300,-48]
[16800,23488,1957.3333333333333,23488,23500,12]
[16900,23628,1969,23628,23600,-28]
[17000,23767,1980.5833333333333,23767,23800,33]
[17100,23907,1992.25,23907,23900,-7]
[17600,24606,2050.5,24606,24600,-6]
[17700,24746,2062.1666666666665,24746,24700,-46]
[18000,25165,2097.0833333333335,25165,25200,35]
[18200,25445,2120.4166666666665,25445,25400,-45]
[18300,25585,2132.0833333333335,25585,25600,15]
[18600,26004,2167,26004,26000,-4]
[18700,26144,2178.6666666666665,26144,26100,-44]
[18800,26284,2190.3333333333335,{"$f":"B228","v":26284},26300,{"$f":"E228-D228","v":16}]
[18900,26424,2202,26424,26400,-24]
[19000,26564,2213.6666666666665,26564,26600,36]
[19100,26703,2225.25,26703,26700,-3]
[19400,27123,2260.25,27123,27100,-23]
[19500,27263,2271.9166666666665,27263,27300,37]
[19600,27402,2283.5,27402,27400,-2]
[19700,27542,2295.1666666666665,27542,27500,-42]
[20000,27962,2330.1666666666665,27962,28000,38]
[20300,28381,2365.0833333333335,28381,28400,19]
[20400,28521,2376.75,28521,28500,-21]
[20500,28661,2388.4166666666665,28661,28700,39]
[20800,29080,2423.3333333333335,29080,29100,20]
[20900,29220,2435,29220,29200,-20]
[21100,29499,2458.25,29499,29500,1]
[21300,29779,2481.5833333333335,29779,29800,21]
[21900,30618,2551.5,30618,30600,-18]
[22000,30758,2563.1666666666665,30758,30800,42]
[22200,31037,{"$f":"VALUE(B246)/12","v":2586.4166666666665},31037,31000,-37]
[22400,31317,2609.75,31317,31300,-17]
[22500,31457,2621.4166666666665,31457,{"$f":"IF(D248<1000,D248,ROUND(D248,-2))","v":31500},43]
[22600,31597,2633.0833333333335,31597,31600,3]
[22900,32016,2668,32016,32000,-16]
[23000,32156,2679.6666666666665,32156,32200,44]
[23200,32435,2702.9166666666665,32435,32400,-35]
[23300,32575,2714.5833333333335,32575,32600,25]
[23400,32715,2726.25,32715,32700,-15]
[23500,32855,2737.9166666666665,32855,32900,45]
[23600,32995,2749.5833333333335,32995,33000,5]
[23700,{"$f":"IF(A257<1000,$B$1*A257,ROUND($B$1*A257,0))","v":33134},2761.1666666666665,33134,33100,-34]
[23800,33274,2772.8333333333335,33274,33300,26]
[23900,33414,2784.5,33414,33400,-14]
[24000,33554,2796.1666666666665,33554,33600,46]
[24500,34253,2854.4166666666665,34253,34300,47]
[24900,34812,2901,34812,34800,-12]
[25000,34952,2912.6666666666665,34952,35000,48]
[25200,35232,2936,35232,35200,-32]
[25400,35511,2959.25,35511,35500,-11]
[25700,35931,2994.25,35931,35900,-31]
[26000,36350,3029.1666666666665,36350,36400,50]
[26300,36769,3064.0833333333335,36769,36800,31]
[26600,37189,3099.0833333333335,37189,37200,11]
[26700,37329,3110.75,37329,37300,-29]
[26900,37608,3134,37608,37600,-8]
[27000,37748,3145.6666666666665,37748,37700,-48]
[27100,37888,3157.3333333333335,37888,37900,12]
[27600,38587,3215.5833333333335,38587,38600,13]
[27700,38727,3227.25,38727,38700,-27]
[28000,39146,3262.1666666666665,39146,39100,-46]
[28100,39286,3273.8333333333335,39286,39300,14]
[29000,40544,3378.6666666666665,40544,40500,-44]
[29100,40684,3390.3333333333335,40684,40700,16]
[29200,40824,3402,40824,40800,-24]
[29300,40964,3413.6666666666665,40964,41000,36]
[29400,41104,3425.3333333333335,41104,41100,-4]
[29900,41803,3483.5833333333335,41803,41800,-3]
[30000,41942,3495.1666666666665,41942,41900,-42]
[30200,42222,3518.5,42222,42200,-22]
[30500,42641,3553.4166666666665,42641,42600,-41]
[30700,42921,3576.75,42921,42900,-21]
[30800,43061,3588.4166666666665,43061,43100,39]
[31800,44459,3704.9166666666665,44459,44500,41]
[32000,44739,3728.25,44739,44700,-39]
[32100,44878,3739.8333333333335,44878,44900,22]
[32500,45438,3786.5,{"$f":"B292","v":45438},45400,{"$f":"E292-D292","v":-38}]
[33000,46137,3844.75,46137,46100,-37]
[33300,46556,3879.6666666666665,46556,46600,44]
[34200,47814,3984.5,47814,47800,-14]
[34300,47954,3996.1666666666665,47954,48000,46]
[34700,48513,4042.75,48513,48500,-13]
[35000,48933,4077.75,{"$f":"B298","v":48933},48900,{"$f":"E298-D298","v":-33}]
[35100,49073,4089.4166666666665,49073,49100,27]
[35200,49212,4101,49212,49200,-12]
[35400,49492,4124.333333333333,49492,49500,8]
[36500,51030,4252.5,51030,51000,-30]
[36700,51309,4275.75,51309,51300,-9]
[37000,51729,4310.75,51729,51700,-29]
[38200,53407,4450.583333333333,53407,53400,-7]
[38900,54385,4532.083333333333,54385,54400,15]
[39200,54805,4567.083333333333,54805,54800,-5]
[40300,56343,4695.25,56343,56300,-43]
[40900,57181,4765.083333333333,57181,57200,19]
[41600,58160,{"$f":"VALUE(B310)/12","v":4846.666666666667},58160,58200,40]
[42000,58719,4893.25,58719,58700,-19]
[42700,59698,4974.833333333333,59698,{"$f":"IF(D312<1000,D312,ROUND(D312,-2))","v":59700},2]
[43300,60537,5044.75,60537,60500,-37]
[43500,60816,5068,60816,60800,-16]
[44000,61515,5126.25,61515,61500,-15]
[44100,61655,5137.916666666667,61655,61700,45]
[44900,62774,5231.166666666667,62774,62800,26]
[45700,63892,5324.333333333333,63892,63900,8]
[46000,64312,5359.333333333333,64312,64300,-12]
[46500,65011,5417.583333333333,65011,65000,-11]
[47000,{"$f":"IF(A321<1000,$B$1*A321,ROUND($B$1*A321,0))","v":65710},5475.833333333333,65710,65700,-10]
[47200,65989,5499.083333333333,65989,66000,11]
[47700,66688,5557.333333333333,66688,66700,12]
[48000,67108,5592.333333333333,67108,67100,-8]
[48600,67947,5662.25,67947,67900,-47]
[48800,68226,5685.5,68226,68200,-26]
[49900,69764,5813.666666666667,69764,69800,36]
[50000,69904,5825.333333333333,69904,69900,-4]
[51300,71721,5976.75,71721,71700,-21]
[52000,72700,6058.333333333333,72700,72700,0]
[53000,74098,6174.833333333333,74098,74100,2]
[53900,75356,6279.666666666667,75356,75400,44]
[55000,76894,6407.833333333333,76894,76900,6]
[56700,79271,6605.916666666667,79271,79300,29]
[56800,79411,6617.583333333333,79411,79400,-11]
[57000,79691,6640.916666666667,79691,79700,9]
[58700,82067,6838.916666666667,82067,82100,33]
[58800,82207,6850.583333333333,82207,82200,-7]
[59000,82487,6873.916666666667,82487,82500,13]
[59900,83745,6978.75,83745,83700,-45]
[60000,83885,6990.416666666667,83885,83900,15]
[62300,87100,7258.333333333333,87100,87100,0]
[63000,88079,7339.916666666667,88079,88100,21]
[63300,88498,7374.833333333333,88498,88500,2]
[63700,89058,7421.5,89058,89100,42]
[65000,90875,7572.916666666667,90875,90900,25]
[66100,92413,7701.083333333333,92413,92400,-13]
[67000,93671,7805.916666666667,93671,93700,29]
[69600,97306,8108.833333333333,97306,97300,-6]
[70400,98425,8202.0833333333339,98425,98400,-25]
[70800,98984,8248.6666666666661,98984,99000,16]
[71000,99264,8272,99264,99300,36]
[71700,100242,8353.5,100242,100200,-42]
[73400,102619,8551.5833333333339,102619,102600,-19]
[73500,102759,8563.25,102759,102800,41]
[78900,110308,9192.3333333333339,110308,110300,-8]
[80600,112685,9390.4166666666661,112685,112700,15]
[82200,114922,9576.8333333333339,114922,114900,-22]
[82600,115481,9623.4166666666661,115481,115500,19]
[82900,115901,9658.4166666666661,115901,115900,-1]
[83300,116460,9705,116460,116500,40]
[87000,121633,10136.083333333334,{"$f":"B362","v":121633},121600,{"$f":"E362-D362","v":-33}]
[88100,123171,10264.25,123171,123200,29]
[90600,126666,10555.5,126666,126700,34]
[93200,130301,10858.416666666666,130301,130300,-1]
[93900,131280,10940,131280,131300,20]
[94400,131979,10998.25,131979,132000,21]
[95300,133237,11103.083333333334,133237,133200,-37]
[96200,134495,11207.916666666666,134495,134500,5]
[102700,143583,11965.25,143583,143600,17]
[102800,143723,11976.916666666666,143723,143700,-23]
[104100,145540,12128.333333333334,145540,145500,-40]
[105600,147637,12303.083333333334,147637,147600,-37]
[106100,148336,{"$f":"VALUE(B374)/12","v":12361.333333333334},148336,148300,-36]
[109400,152950,12745.833333333334,152950,153000,50]
[110000,153789,12815.75,153789,{"$f":"IF(D376<1000,D376,ROUND(D376,-2))","v":153800},11]
[116200,162457,13538.083333333334,162457,162500,43]
[117300,163995,13666.25,163995,164000,5]
[117400,164134,13677.833333333334,164134,164100,-34]
[118000,164973,13747.75,164973,165000,27]
[118300,165393,13782.75,165393,165400,7]
[123400,172523,14376.916666666666,172523,172500,-23]
[124700,174340,14528.333333333334,174340,174300,-40]
[127100,177696,14808,177696,177700,4]
[129100,{"$f":"IF(A385<1000,$B$1*A385,ROUND($B$1*A385,0))","v":180492},15041,180492,180500,8]
[129800,181471,15122.583333333334,181471,181500,29]
[130900,183009,15250.75,183009,183000,-9]
[131900,184407,15367.25,184407,184400,-7]
[133400,186504,15542,186504,186500,-4]
[139400,194892,16241,194892,194900,8]
[140900,196989,16415.75,196989,197000,11]
[141600,197968,16497.333333333332,197968,198000,32]
[145000,202721,16893.416666666668,202721,202700,-21]
[146600,204958,17079.833333333332,204958,205000,42]
[147700,206496,17208,206496,206500,4]

{"sheet":"reguleringsprocenter","index":1,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Reguleringsprocenter",null,"pensionsudbygning"]
[null,"Valgt:",{"$f":"VLOOKUP(Forside!K11,reguleringsprocenter!B4:D15,2,TRUE)","v":1.4983040000000001}]
[null,"2019-04-01",1.3772530000000001,1]
[null,"2019-10-01",1.3908609999999999,1]
[null,"2020-01-01",1.4124110000000001,1]
[null,"2020-04-01",1.4177979999999999,1]
[null,"2020-10-01",1.4285110000000001,1]
[null,"2021-04-01",1.442796,1]
[null,"2021-10-01",1.456933,1]
[null,"2022-04-01",1.456933,1]
[null,"2022-10-01",1.4940180000000001,1]
[null,"2023-04-01",1.4983040000000001,1]
[null,"2023-10-01",1.5169710000000001,1]
[]
[]
[]
[null,"Liste, opslag niveauer"]
[]
[null,"2023-10-01"]
[null,"2023-04-01"]
[null,"2022-10-01"]
[null,"2022-04-01"]
[null,"2021-10-01"]
[null,"2021-04-01"]
[null,"2020-10-01"]
[null,"2020-04-01"]
[null,"2020-01-01"]
[null,"2019-10-01"]
[null,"2019-04-01"]

{"sheet":"Lønark","index":2,"n_rows":71,"n_cols":88,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56]
["Næstved",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Løn","Årsløn",null,null,"Ureguleret ikke-pensionsgivende tillæg",null,null,null,"Årsløn ialt ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lavtlønsprojekt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Løn","Årsløn",null,null,"Ureguleret ikke-pensionsgivende tillæg",null,null,null,null,null,null,null,null,null,"Områdetillæg inkl. regulering",null,null,null,null,"Årsløn ialt ",null,null,null,null,null,"Pensionsgivende løn",null,null,null,null,null,null,null,null,"Pensionsgivende løn",null,null,null,null,null,"Løn","timelønninger",null,null,null,null,null,"Løn","timelønninger + 50%",null,null,null,null,null,"Løn","søndagstillæg - 50%",null,null,null,null,null,null,"2019-03-31",0,0]
[null,"Månedsløn, løngrupper",null,null,"Lønniveau:",{"$f":"VLOOKUP(beregningsdato,regpct_tabel,1,TRUE)","v":"2023-04-01"},null,"Optrapning fra:",null,null,null,null,"Pensionsgivende løn",null,null,null,null,null,"Pensionsgivende løn, optrapning fra:",null,null,null,null,"trin","Grundsats","%-reg.","Sats","Omr 1","Omr 2","Omr 3","Omr 4",null,null,null,null,null,null,1,2,3,4,null,"Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"Grundsats","%-reg.","Sats",null,"Pensionsudbygningspct:",null,null,{"$f":"VLOOKUP(F4,regpct_tabel,3,FALSE)","v":1},null,"Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"trin","Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"trin","Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"trin","Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,null,"2019-04-01",382,0]
[null,0,1,2,3,4,null,"0->1","1->2","2->3",null,null,0,1,2,3,4,null,"0->1","1->2","2->3","3->4",null,null,{"$f":"VLOOKUP(beregningsdato,Lavtløn,2,TRUE)","v":1035},{"$f":"valgt_regulering-1","v":0.49830400000000008},"2019-04-01","2022-04-01",{"$f":"VLOOKUP(beregningsdato,Lavtløn,3,TRUE)","v":653},null,null,null,null,null,null,null,null,{"$f":"IF(beregningsdato<40087,0,regulering)","v":0.49830400000000008},{"$f":"IF(beregningsdato<40087,0,5)","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-04-01",{"$f":"CI4+CJ5","v":1035},653]
[1,{"$f":"AQ6/12","v":18378.416666666668},18638.333333333332,18818.333333333332,19078.333333333332,19258.333333333332,null,{"$f":"ROUND(AQ6+(AR6-AQ6)/3*faktor,0)/12","v":20200647.666666668},{"$f":"ROUND(AR6+(AS6-AR6)/3*faktor,0)/12","v":13995458.333333334},{"$f":"ROUND(AS6+(AT6-AS6)/3*faktor,0)/12","v":20207558.333333332},null,1,{"$f":"BF6/12","v":18378.416666666668},18638.333333333332,18818.333333333332,19078.333333333332,19258.333333333332,null,{"$f":"(BF6+ROUND((BG6-BF6)/3*faktor,0))/12","v":20200647.666666668},{"$f":"(BG6+ROUND((BH6-BG6)/3*faktor,0))/12","v":13995458.333333334},{"$f":"(BH6+ROUND((BI6-BH6)/3*faktor,0))/12","v":20207558.333333332},{"$f":"(BI6+ROUND((BJ6-BI6)/3*faktor,0))/12","v":13995898.333333334},null,1,147194,{"$f":"ROUND(Y6*regulering,0)","v":73347},{"$f":"Y6+Z6","v":220541},2585,4374,6959,8748,null,2082,3523,5606,7047,null,{"$f":"ROUND(VLOOKUP($X6,$X:$AJ,(4+AL$4)+$AM$5)*(1+$AL$5),0)","v":3119},5279,8399,10559,null,{"$f":"$AA6","v":220541},{"$f":"$AA6+AL6","v":223660},225820,228940,231100,null,147194,{"$f":"AW6*regulering","v":73347.358976000018},{"$f":"ROUND(SUM(AW6:AX6),0)","v":220541},null,{"$f":"ROUND(AL6*udbygningspct,0)","v":3119},{"$f":"ROUND(AM6*udbygningspct,0)","v":5279},{"$f":"ROUND(AN6*udbygningspct,0)","v":8399},{"$f":"ROUND(AO6*udbygningspct,0)","v":10559},null,{"$f":"AY6","v":220541},{"$f":"$BF6+BA6","v":223660},{"$f":"$BF6+BB6","v":225820},228940,231100,null,1,{"$f":"AQ6/1924","v":114.62629937629937},116.24740124740124,117.37006237006237,118.99168399168398,120.11434511434511,null,1,{"$f":"AQ6/1924*1.5","v":171.93944906444906},{"$f":"AR6/1924*1.5","v":174.37110187110187},{"$f":"AS6/1924*1.5","v":176.05509355509355},{"$f":"AT6/1924*1.5","v":178.48752598752597},{"$f":"AU6/1924*1.5","v":180.17151767151768},null,1,{"$f":"AQ6/1924/2","v":57.313149688149686},58.123700623700621,58.685031185031185,59.495841995841992,60.057172557172557]
[2,18660.75,18927.083333333332,19111.333333333332,19377.666666666668,19562,null,20699177.75,14325755.333333334,20699628.333333332,null,2,18660.75,18927.083333333332,19111.333333333332,19377.666666666668,19562,null,20699177.75,14325755.333333334,20699628.333333332,14332676.666666666,null,2,149455,74474,223929,2648,4481,7128,8961,null,2133,3609,5742,7218,null,3196,5407,8603,10815,null,{"$f":"$AA7","v":223929},227125,229336,232532,234744,null,149455,{"$f":"AW7*regulering","v":74474.024320000011},{"$f":"ROUND(SUM(AW7:AX7),0)","v":223929},null,3196,5407,8603,10815,null,{"$f":"AY7","v":223929},227125,229336,232532,234744,null,2,116.38721413721414,118.04833679833679,119.19750519750519,120.85862785862786,122.00831600831602,null,2,{"$f":"AQ7/1924*1.5","v":174.58082120582122},177.07250519750519,178.79625779625781,181.28794178794178,183.01247401247403,null,2,58.193607068607072,59.024168399168396,59.598752598752597,60.429313929313928,61.004158004158008]
[3,18950.666666666668,19223.333333333332,19412.25,19685,19874,null,21191244.666666668,14688413.583333334,21198177,null,3,18950.666666666668,19223.333333333332,19412.25,19685,19874,null,21191244.666666668,14688413.583333334,21198177,14695346,null,3,151777,75631,227408,2711,4590,7301,9180,null,2184,3697,5881,7395,null,3272,5539,8812,11080,null,227408,230680,232947,236220,238488,null,151777,75631.086208000008,227408,null,3272,5539,8812,11080,null,227408,230680,232947,236220,238488,null,3,118.19542619542619,119.8960498960499,121.07432432432432,122.77546777546777,123.95426195426195,null,3,177.29313929313929,179.84407484407484,181.61148648648648,184.16320166320168,185.93139293139293,null,3,59.097713097713097,59.948024948024951,60.537162162162161,61.387733887733887,61.977130977130976]
[4,19248.583333333332,19528.166666666668,19721.583333333332,20001.083333333332,20194.5,null,21728614.833333332,15038138.916666666,21722617.083333332,null,4,19248.583333333332,19528.166666666668,19721.583333333332,20001.083333333332,20194.5,null,21728614.833333332,15038138.916666666,21722617.083333332,15038611.833333334,null,4,154163,76820,230983,2779,4703,7482,9405,null,2239,3788,6027,7576,null,3355,5676,9030,11351,null,230983,234338,236659,240013,242334,null,154163,76820.039552000017,230983,null,3355,5676,9030,11351,null,230983,234338,236659,240013,242334,null,4,120.05353430353431,121.79729729729729,123.00363825363826,124.7468814968815,125.95322245322245,null,4,180.08030145530145,182.69594594594594,184.50545738045739,187.12032224532226,188.92983367983368,null,4,60.026767151767153,60.898648648648646,61.501819126819129,62.37344074844075,62.976611226611226]
[5,19554.583333333332,19840.916666666668,20039.25,20325.583333333332,20523.75,null,22253051.583333332,15420225.916666666,22253536.25,null,5,19554.583333333332,19840.916666666668,20039.25,20325.583333333332,20523.75,null,22253051.583333332,15420225.916666666,22253536.25,15407769.083333334,null,5,156614,78041,234655,2847,4819,7666,9636,null,2293,3882,6175,7762,null,3436,5816,9252,11630,null,234655,238091,240471,243907,246285,null,156614,78041.382656000016,234655,null,3436,5816,9252,11630,null,234655,238091,240471,243907,246285,null,5,121.96205821205821,123.747920997921,124.98492723492724,126.77079002079002,128.00675675675674,null,5,182.94308731808732,185.62188149688149,187.47739085239087,190.15618503118503,192.0101351351351,null,5,60.981029106029105,61.8739604989605,62.492463617463621,63.385395010395008,64.003378378378372]
[6,19869.416666666668,20162.833333333332,20366,20659.25,20862.416666666668,null,22803380.166666668,15795851.333333334,22790935.25,null,6,19869.416666666668,20162.833333333332,20366,20659.25,20862.416666666668,null,22803380.166666668,15795851.333333334,22790935.25,15796347.75,null,6,159135,79298,238433,2917,4937,7854,9873,null,2350,3977,6326,7953,null,3521,5959,9478,11916,null,238433,241954,244392,247911,250349,null,159135,79297.607040000017,238433,null,3521,5959,9478,11916,null,238433,241954,244392,247911,250349,null,6,123.92567567567568,125.75571725571726,127.02286902286902,128.8518711018711,130.11902286902287,null,6,185.88851351351352,188.63357588357587,190.53430353430352,193.27780665280665,195.17853430353432,null,6,61.962837837837839,62.877858627858629,63.511434511434508,64.425935550935549,65.059511434511435]
[7,20192.25,20492.916666666668,20701.166666666668,21001.833333333332,21209.833333333332,null,23366658.25,16190897.166666666,23367167.166666668,null,7,20192.25,20492.916666666668,20701.166666666668,21001.833333333332,21209.833333333332,null,23366658.25,16190897.166666666,23367167.166666668,16171993.833333334,null,7,161721,80586,242307,2989,5060,8049,10118,null,2408,4076,6484,8150,null,3608,6107,9715,12211,null,242307,245915,248414,252022,254518,null,161721,80586.221184000009,242307,null,3608,6107,9715,12211,null,242307,245915,248414,252022,254518,null,7,125.93918918918919,127.81444906444906,129.11330561330561,130.98856548856548,132.28586278586278,null,7,188.9087837837838,191.72167359667361,193.66995841995842,196.48284823284823,198.42879417879416,null,7,62.969594594594597,63.907224532224532,64.556652806652806,65.494282744282742,66.142931392931388]
[8,20536.416666666668,20844.833333333332,21058.416666666668,21366.75,21580.25,null,23968782.166666668,16605377.083333334,23962833.416666668,null,8,20536.416666666668,20844.833333333332,21058.416666666668,21366.75,21580.25,null,23968782.166666668,16605377.083333334,23962833.416666668,16599428.25,null,8,164477,81960,246437,3067,5190,8256,10379,null,2470,4181,6650,8360,null,3701,6264,9964,12526,null,246437,250138,252701,256401,258963,null,164477,81959.547008000009,246437,null,3701,6264,9964,12526,null,246437,250138,252701,256401,258963,null,8,128.08575883575884,130.00935550935552,131.3414760914761,133.264553014553,134.59615384615384,null,8,192.12863825363826,195.01403326403329,197.01221413721413,199.89682952182949,201.89423076923077,null,8,64.042879417879419,65.004677754677758,65.670738045738048,66.632276507276501,67.29807692307692]
[9,21182.416666666668,21498.583333333332,21717.333333333332,22033.333333333332,22252.166666666668,null,{"$f":"ROUND(AQ14+(AR14-AQ14)/3*faktor,0)/12","v":24571207.916666668},{"$f":"ROUND(AR14+(AS14-AR14)/3*faktor,0)/12","v":17007217.333333332},{"$f":"ROUND(AS14+(AT14-AS14)/3*faktor,0)/12","v":24558801.333333332},null,9,21182.416666666668,21498.583333333332,21717.333333333332,22033.333333333332,22252.166666666668,null,{"$f":"(BF14+ROUND((BG14-BF14)/3*faktor,0))/12","v":24571207.916666668},{"$f":"(BG14+ROUND((BH14-BG14)/3*faktor,0))/12","v":17007217.333333332},{"$f":"(BH14+ROUND((BI14-BH14)/3*faktor,0))/12","v":24558801.333333332},{"$f":"(BI14+ROUND((BJ14-BI14)/3*faktor,0))/12","v":17014222.833333332},null,9,169651,84538,254189,3143,5319,8461,10637,null,2532,4284,6815,8568,null,3794,6419,10211,12837,{"$f":"AR14/12","v":21498.583333333332},254189,{"$f":"ROUND($AA14+AL14,0)","v":257983},{"$f":"$AA14+AM14","v":260608},{"$f":"$AA14+AN14","v":264400},{"$f":"$AA14+AO14","v":267026},null,169651,84537.771904000008,254189,null,3794,6419,10211,12837,null,254189,257983,260608,264400,267026,null,9,132.11486486486487,134.08679833679832,135.45114345114345,137.42203742203742,138.78690228690229,null,9,198.17229729729729,201.13019750519749,203.17671517671516,206.13305613305613,208.18035343035342,null,9,66.057432432432435,67.043399168399162,67.725571725571726,68.71101871101871,69.393451143451145]
[10,21332,21656,21880.25,22204.166666666668,22428.5,null,25179608,17434444.25,25173685.5,null,10,21332,21656,21880.25,22204.166666666668,22428.5,null,25179608,17434444.25,25173685.5,17441463.166666668,null,10,170849,85135,255984,3221,5451,8672,10903,null,2595,4391,6985,8782,null,3888,6579,10466,13158,null,255984,{"$f":"$AA15+AL15","v":259872},262563,266450,269142,null,170849,85134.740096000009,255984,null,3888,6579,10466,13158,null,255984,259872,262563,266450,269142,null,10,133.04781704781703,135.06860706860707,136.46725571725571,138.487525987526,139.88669438669439,null,10,199.57172557172555,202.60291060291058,204.70088357588355,207.731288981289,209.83004158004158,null,10,66.523908523908517,67.534303534303533,68.233627858627855,69.243762993762999,69.943347193347194]
[11,21738.166666666668,22070.166666666668,22300.166666666668,22632.166666666668,22862.166666666668,null,25801206.166666668,17881340.166666668,25801768.166666668,null,11,21738.166666666668,22070.166666666668,22300.166666666668,22632.166666666668,22862.166666666668,null,25801206.166666668,17881340.166666668,25801768.166666668,17881902.166666668,null,11,173067,{"$f":"IF(beregningsdato>=$AA$5,ROUND((Y16+$Y$5)*regulering,0),ROUND(Y16*regulering,0))","v":86756},{"$f":"IF(beregningsdato>=$AA$5,SUM($Y$5,Y16:Z16),SUM(Y16:Z16))","v":260858},3301,5588,8889,11175,2659,2659,4501,7160,9002,null,3984,6744,10728,13488,null,260858,264842,267602,271586,274346,null,173067,{"$f":"IF(beregningsdato>=$AA$5,ROUND((AW16+$Y$5)*regulering,0),ROUND(AW16*regulering,0))","v":86756},{"$f":"IF(beregningsdato>=$AA$5,SUM($Y$5,AW16:AX16),SUM(AW16:AX16))","v":260858},null,3984,6744,10728,13488,null,260858,264842,267602,271586,274346,null,11,135.58108108108109,137.65176715176716,139.08627858627858,141.15696465696465,142.5914760914761,null,11,203.37162162162164,206.47765072765074,208.62941787941787,211.73544698544697,213.88721413721413,null,11,67.790540540540547,68.82588357588358,69.543139293139291,70.578482328482323,71.295738045738048]
[12,22108.333333333332,22448.666666666668,22684.333333333332,23024.833333333332,23260.416666666668,null,26448651.333333332,18321729.666666668,26462168.833333332,null,12,22108.333333333332,22448.666666666668,22684.333333333332,23024.833333333332,23260.416666666668,null,26448651.333333332,18321729.666666668,26462168.833333332,18315835.083333332,null,12,176032,{"$f":"IF(beregningsdato>=$AA$5,ROUND((Y17+$Y$5)*regulering,0),ROUND(Y17*regulering,0))","v":88233},265300,3384,5727,9112,11455,2726,2726,4613,7340,9227,null,4084,6912,10998,13825,null,265300,269384,272212,276298,279125,null,176032,{"$f":"IF(beregningsdato>=$AA$5,ROUND((AW17+$Y$5)*regulering,0),ROUND(AW17*regulering,0))","v":88233},265300,null,4084,6912,10998,13825,null,265300,269384,272212,276298,279125,null,12,137.8898128898129,140.012474012474,141.48232848232848,143.6060291060291,145.07536382536384,null,12,206.83471933471935,210.018711018711,212.22349272349271,215.40904365904365,217.61304573804574,null,12,68.944906444906451,70.006237006237001,70.741164241164242,71.803014553014549,72.537681912681919]
[13,22489.083333333332,22838.083333333332,23079.666666666668,23428.666666666668,23670.25,null,27121990.083333332,18781542.333333332,27122580.666666668,null,13,22489.083333333332,22838.083333333332,23079.666666666668,23428.666666666668,23670.25,null,27121990.083333332,18781542.333333332,27122580.666666668,18782132.916666668,null,13,179081,{"$f":"IF(beregningsdato>=$AA$5,ROUND((Y18+$Y$5)*regulering,0),ROUND(Y18*regulering,0))","v":89753},269869,3470,5872,9342,11744,2795,2795,4730,7525,9460,null,4188,7087,11275,14174,null,269869,274057,276956,281144,284043,null,179081,{"$f":"IF(beregningsdato>=$AA$5,ROUND((AW18+$Y$5)*regulering,0),ROUND(AW18*regulering,0))","v":89753},269869,null,4188,7087,11275,14174,null,269869,274057,276956,281144,284043,null,13,140.264553014553,142.44126819126819,143.94802494802494,146.12474012474013,147.63149688149687,null,13,210.39682952182949,213.66190228690229,215.92203742203742,219.18711018711019,221.44724532224529,null,13,70.132276507276501,71.220634095634097,71.974012474012468,73.062370062370064,73.815748440748436]
[14,22880.25,23238,23485.583333333332,23843.416666666668,24091.166666666668,null,27801810,19247836.25,27808886.083333332,null,14,22880.25,23238,23485.583333333332,23843.416666666668,24091.166666666668,null,27801810,19247836.25,27808886.083333332,19261383.166666668,null,14,182214,91314,274563,3557,6019,9577,12039,2865,2865,4848,7714,9698,null,4293,7264,11558,14531,null,274563,278856,281827,286121,289094,null,182214,91314,274563,null,4293,7264,11558,14531,null,274563,278856,281827,286121,289094,null,14,142.70426195426197,144.93555093555094,146.47972972972974,148.71153846153845,150.25675675675674,null,14,214.05639293139296,217.40332640332639,219.71959459459461,223.06730769230768,225.3851351351351,null,14,71.352130977130983,72.467775467775468,73.23986486486487,74.355769230769226,75.128378378378372]
[15,23266.5,23633.25,23887.333333333332,24253.916666666668,24507.833333333332,null,28501037.25,19752950,28488716.583333332,null,15,23266.5,23633.25,23887.333333333332,24253.916666666668,24507.833333333332,null,28501037.25,19752950,28488716.583333332,19740629.166666668,null,15,185308,92855,279198,3646,6172,9818,12343,2937,2937,4972,7908,9942,null,4401,7450,11849,14896,null,279198,283599,286648,291047,294094,null,185308,92855,279198,null,4401,7450,11849,14896,null,279198,283599,286648,291047,294094,null,15,145.11330561330561,147.40072765072765,148.985446985447,151.27182952182952,152.85550935550935,null,15,217.66995841995842,221.10109147609148,223.47817047817051,226.90774428274426,229.28326403326403,null,15,72.556652806652806,73.700363825363823,74.492723492723499,75.635914760914758,76.427754677754677]
[16,23662,24037.916666666668,24298.25,24674.25,24934.833333333332,null,29213215.25,20238660.916666668,29220322.25,null,16,23662,24037.916666666668,24298.25,24674.25,24934.833333333332,null,29213215.25,20238660.916666668,29220322.25,20258709.5,null,16,188475,94434,283944,3738,6327,10065,12655,3011,3011,5096,8107,10194,null,4511,7635,12147,15274,null,283944,288455,291579,296091,299218,null,188475,94434,283944,null,4511,7635,12147,15274,null,283944,288455,291579,296091,299218,null,16,147.58004158004158,149.92463617463616,151.54833679833681,153.89345114345113,155.51871101871103,null,16,221.37006237006239,224.88695426195426,227.32250519750522,230.84017671517671,233.27806652806655,null,16,73.79002079002079,74.962318087318081,75.774168399168403,76.946725571725565,77.759355509355515]
[17,{"$f":"AQ22/12","v":23990.5},24377.833333333332,24646,25033.416666666668,25301.5,null,30100036.5,20847251.333333332,30107162.75,null,17,{"$f":"BF22/12","v":23990.5},24377.833333333332,24646,25033.416666666668,25301.5,null,30100036.5,20847251.333333332,30107162.75,20841436.166666668,null,17,191106,95745,287886,3851,6518,10370,13035,3102,3102,5250,8353,10500,null,4648,7866,12515,15732,null,287886,292534,295752,300401,303618,null,191106,95745,287886,null,4648,7866,12515,15732,null,287886,{"$f":"$BF22+BA22","v":292534},295752,300401,303618,null,17,{"$f":"AQ22/1924","v":149.62889812889813},152.04469854469855,153.71725571725571,156.13357588357587,157.80561330561329,null,17,224.44334719334719,228.06704781704781,230.57588357588355,234.20036382536381,236.70841995841994,null,17,{"$f":"AQ22/1924/2","v":74.814449064449065},76.022349272349274,76.858627858627855,78.066787941787936,78.902806652806646]
[18,24428.583333333332,24825.75,25100.666666666668,25498,25772.916666666668,null,30864023.083333332,21371830,30877636.666666668,null,18,24428.583333333332,24825.75,25100.666666666668,25498,25772.916666666668,null,30864023.083333332,21371830,30877636.666666668,21372502.25,null,18,194615,97493,293143,3949,6683,10633,13367,3181,3181,5383,8565,10767,null,4766,8065,12833,16132,null,293143,297909,301208,305976,309275,null,194615,97493,293143,null,4766,8065,12833,16132,null,293143,297909,301208,305976,309275,null,18,152.36122661122661,154.83835758835758,156.55301455301455,159.03118503118503,160.745841995842,null,18,{"$f":"AQ23/1924*1.5","v":228.54183991683993},232.25753638253639,234.82952182952181,238.54677754677755,241.118762993763,null,18,76.180613305613306,77.419178794178791,78.276507276507274,79.515592515592516,80.372920997921]
[19,24756.583333333332,25163.833333333332,25445.916666666668,25853.25,26135.25,null,31647311.833333332,21928652.583333332,31654471.916666668,null,19,24756.583333333332,25163.833333333332,25445.916666666668,25853.25,26135.25,null,31647311.833333332,21928652.583333332,31654471.916666668,21922871.25,null,19,197242,98802,297079,4050,6854,10904,13708,3262,3262,5521,8783,11042,null,4887,8272,13160,16544,null,297079,301966,305351,310239,313623,null,197242,98802,297079,null,4887,8272,13160,16544,null,297079,301966,305351,310239,313623,null,19,154.40696465696465,156.94698544698545,158.70634095634097,161.24688149688149,163.00571725571726,null,19,231.61044698544697,235.42047817047819,238.05951143451145,241.87032224532223,244.50857588357587,null,19,77.203482328482323,78.473492723492726,79.353170478170483,80.623440748440743,81.502858627858629]
[20,25049.416666666668,25467.083333333332,25756.25,26174,26463.083333333332,null,32456448.416666668,22478969.583333332,32463626,null,20,25049.416666666668,25467.083333333332,25756.25,26174,26463.083333333332,null,32456448.416666668,22478969.583333332,32463626,22473205.75,null,20,199969,{"$f":"IF(beregningsdato>=$AB$5,ROUND((Y25+$AC$5)*regulering,0),ROUND(Y25*regulering,0))","v":99971},{"$f":"IF(beregningsdato>=$AB$5,SUM($AC$5,Y25:Z25),SUM(Y25:Z25))","v":300593},4153,7028,11182,14056,3345,3345,5661,9007,11322,null,5012,8482,13495,16964,null,300593,305605,309075,314088,317557,null,199969,{"$f":"IF(beregningsdato>=$AB$5,ROUND((AW25+$AC$5)*regulering,0),ROUND(AW25*regulering,0))","v":99971},{"$f":"IF(beregningsdato>=$AB$5,SUM($AC$5,AW25:AX25),SUM(AW25:AX25))","v":300593},null,5012,8482,13495,16964,null,300593,305605,309075,314088,317557,null,20,156.23336798336797,158.83835758835758,160.6418918918919,163.24740124740126,165.05041580041581,null,20,234.35005197505194,238.25753638253639,240.96283783783787,244.87110187110187,247.57562370062371,null,20,78.116683991683985,79.419178794178791,80.320945945945951,81.623700623700628,82.525207900207903]
[21,25463.583333333332,25892,26188.5,26616.916666666668,26913.416666666668,null,33291589.333333332,23048820.5,33292314.25,null,21,25463.583333333332,25892,26188.5,26616.916666666668,26913.416666666668,null,33291589.333333332,23048820.5,33292314.25,23049545.416666668,null,21,203286,{"$f":"IF(beregningsdato>=$AB$5,ROUND((Y26+$AC$5)*regulering,0),ROUND(Y26*regulering,0))","v":101624},{"$f":"IF(beregningsdato>=$AB$5,SUM($AC$5,Y26:Z26),SUM(Y26:Z26))","v":305563},4259,7208,11467,14416,3431,3431,5806,9237,11612,null,{"$f":"ROUND(VLOOKUP($X26,$X:$AJ,(4+AL$4)+$AM$5)*(1+$AL$5),0)","v":5141},8699,13840,17398,null,305563,310704,314262,319403,322961,null,203286,{"$f":"IF(beregningsdato>=$AB$5,ROUND((AW26+$AC$5)*regulering,0),ROUND(AW26*regulering,0))","v":101624},{"$f":"IF(beregningsdato>=$AB$5,SUM($AC$5,AW26:AX26),SUM(AW26:AX26))","v":305563},null,5141,8699,13840,17398,null,305563,310704,314262,319403,322961,null,21,158.81652806652806,161.48856548856548,163.33783783783784,166.00987525987526,167.85914760914761,null,21,238.2247920997921,242.23284823284823,245.00675675675677,249.0148128898129,251.78872141372142,null,21,79.408264033264032,80.744282744282742,81.668918918918919,83.004937629937629,83.929573804573806]
[22,25766.083333333332,26194.5,26491,26919.416666666668,27215.916666666668,null,33291891.833333332,23049123,33292616.75,null,22,25766.083333333332,26194.5,26491,26919.416666666668,27215.916666666668,null,33291891.833333332,23049123,33292616.75,23049847.916666668,null,22,206362,102831,309193,4259,7208,11467,14416,null,3431,5806,9237,11612,null,5141,8699,13840,17398,null,309193,314334,317892,323033,326591,null,206362,102831.01004800001,309193,null,5141,8699,13840,17398,null,309193,314334,317892,323033,326591,null,22,160.70322245322245,163.37525987525987,165.22453222453223,167.89656964656965,169.745841995842,null,22,241.05483367983368,245.06288981288981,247.83679833679832,251.84485446985445,254.618762993763,null,22,80.351611226611226,81.687629937629936,82.612266112266113,83.948284823284823,84.872920997921]
[23,26177,26593.75,26882.083333333332,27298.75,27587.166666666668,null,32386397.75,22415388.75,32380632.083333332,null,23,26177,26593.75,26882.083333333332,27298.75,27587.166666666668,null,32386397.75,22415388.75,32380632.083333332,22422564.5,null,23,209653,104471,314124,4144,7010,11153,14021,null,3338,5647,8984,11294,null,5001,8461,13461,16922,null,314124,319125,322585,327585,331046,null,209653,104470.92851200001,314124,null,5001,8461,13461,16922,null,314124,319125,322585,327585,331046,null,23,163.26611226611226,165.86538461538461,167.66372141372142,170.262474012474,172.06133056133055,null,23,244.89916839916839,248.79807692307691,251.49558212058213,255.393711018711,258.09199584199581,null,23,81.63305613305613,82.932692307692307,83.831860706860709,85.131237006237001,86.030665280665275]
[24,26601,27005.833333333332,27286.083333333332,27690.916666666668,27971.083333333332,null,31461504.5,21788138.083333332,31462189.583333332,null,24,26601,27005.833333333332,27286.083333333332,27690.916666666668,27971.083333333332,null,31461504.5,21788138.083333332,31462189.583333332,21782352.416666668,null,24,213049,106163,319212,4025,6812,10837,13623,null,3242,5487,8729,10973,null,4858,8221,13079,16441,null,319212,324070,327433,332291,335653,null,213049,106163.16889600002,319212,null,4858,8221,13079,16441,null,319212,324070,327433,332291,335653,null,24,165.9106029106029,168.43555093555094,170.18347193347194,172.70841995841997,174.4558212058212,null,24,248.86590436590436,252.65332640332639,255.2752079002079,259.06262993762994,261.68373180873181,null,24,82.955301455301452,84.217775467775468,85.091735966735968,86.354209979209983,87.227910602910598]
[25,27033.916666666668,27426.083333333332,27697.5,28089.833333333332,{"$f":"AU30/12","v":28361.25},null,30478383.416666668,21102658.833333332,30491988.5,null,25,27033.916666666668,27426.083333333332,27697.5,28089.833333333332,28361.25,null,30478383.416666668,21102658.833333332,30491988.5,21103322.583333332,null,25,216516,107891,324407,3899,6598,10499,13198,null,3141,5315,8457,10631,null,4706,7963,12671,15928,null,324407,329113,332370,337078,340335,null,216516,107890.78886400002,324407,null,4706,7963,12671,15928,null,324407,329113,332370,337078,340335,null,25,168.61070686070687,171.05665280665281,172.74948024948026,175.19646569646571,176.88929313929313,null,25,252.91606029106032,256.58497920997922,259.12422037422039,262.79469854469858,265.33393970893968,null,25,84.305353430353435,85.528326403326403,86.374740124740129,87.598232848232854,88.444646569646565]
[26,27476.75,27855.583333333332,28117.666666666668,28496.25,28758.416666666668,null,29443506.25,20378364.333333332,29424734.916666668,null,26,27476.75,27855.583333333332,28117.666666666668,28496.25,28758.416666666668,null,29443506.25,20378364.333333332,29424734.916666668,20385475.75,null,26,220063,109658,329721,3766,6372,10137,12743,null,3034,5133,8165,10265,null,4546,7691,12234,15380,null,329721,334267,337412,341955,345101,null,220063,109658.27315200002,329721,null,4546,7691,12234,15380,null,329721,334267,337412,341955,345101,null,26,171.37266112266113,173.735446985447,175.37006237006236,177.73128898128897,179.36642411642413,null,26,257.05899168399168,260.60317047817051,263.05509355509355,266.59693347193343,269.04963617463619,null,26,85.686330561330564,86.867723492723499,87.685031185031178,88.865644490644485,89.683212058212064]
[27,27929.75,28294,28545.916666666668,28910.166666666668,29162.25,null,28311578,19589371.25,28312194.166666668,null,27,27929.75,28294,28545.916666666668,28910.166666666668,29162.25,null,28311578,19589371.25,28312194.166666668,19602928.916666668,null,27,223691,111466,335157,3621,6127,9748,12254,null,2917,4935,7852,9871,null,4371,7394,11765,14790,null,335157,339528,342551,346922,349947,null,223691,111466.12006400002,335157,null,4371,7394,11765,14790,null,335157,339528,342551,346922,349947,null,27,174.19802494802494,176.46985446985448,178.04106029106029,180.31288981288981,181.88513513513513,null,27,261.29703742203742,264.70478170478174,267.06159043659045,270.46933471933471,272.82770270270271,null,27,87.099012474012468,88.234927234927241,89.020530145530145,90.156444906444904,90.942567567567565]
[28,28392.75,28741.5,28982.833333333332,29331.583333333332,29572.75,null,27108481.5,18768033.5,27109071.583333332,null,28,28392.75,28741.5,28982.833333333332,29331.583333333332,29572.75,null,27108481.5,18768033.5,27109071.583333332,18755682.083333332,null,28,227399,113314,340713,3467,5867,9334,11733,null,2793,4726,7519,9451,null,4185,7081,11266,14160,null,340713,344898,347794,351979,354873,null,227399,113313.83129600002,340713,null,4185,7081,11266,14160,null,340713,344898,347794,351979,354873,null,28,177.08575883575884,179.26091476091477,180.76611226611226,182.94126819126819,184.44542619542619,null,28,265.62863825363826,268.89137214137213,271.14916839916839,274.41190228690232,276.66813929313929,null,28,88.542879417879419,89.630457380457386,90.38305613305613,91.470634095634097,92.222713097713097]
[29,28866.166666666668,29198.416666666668,29428.25,29760.416666666668,29990.416666666668,null,25827746.416666668,17875526.916666668,25821837.75,null,29,28866.166666666668,29198.416666666668,29428.25,29760.416666666668,29990.416666666668,null,25827746.416666668,17875526.916666668,25821837.75,17889030.416666668,null,29,231191,115203,346394,3303,5589,8891,11178,null,2661,4502,7162,9004,null,3987,6745,10731,13491,null,346394,350381,353139,357125,359885,null,231191,115203.40006400002,346394,null,3987,6745,10731,13491,null,346394,350381,353139,357125,359885,null,29,180.03846153846155,182.11070686070687,183.5441787941788,185.61590436590436,187.05041580041581,null,29,270.05769230769232,273.16606029106032,275.31626819126819,278.42385654885652,280.57562370062374,null,29,90.019230769230774,91.055353430353435,91.772089397089402,92.807952182952178,93.525207900207903]
[30,29349.916666666668,29664.416666666668,29882.333333333332,30196.666666666668,30414.5,null,24449960.416666668,16950675.666666668,24437551.333333332,null,30,29349.916666666668,29664.416666666668,29882.333333333332,30196.666666666668,30414.5,null,24449960.416666668,16950675.666666668,24437551.333333332,16944737.166666668,null,30,235065,117134,352199,3127,5293,8420,10585,null,2519,4264,6782,8526,null,3774,6389,10161,12775,null,352199,355973,358588,362360,364974,null,235065,117133.82976000002,352199,null,3774,6389,10161,12775,null,352199,355973,358588,362360,364974,null,30,183.05561330561329,185.01715176715177,186.37629937629939,188.33679833679832,189.69542619542619,null,30,274.58341995841994,277.52572765072767,279.56444906444909,282.50519750519749,284.54313929313929,null,30,91.527806652806646,92.508575883575887,93.188149688149693,94.168399168399162,94.847713097713097]
[31,29844.583333333332,30140.5,30345.25,30641.166666666668,30845.916666666668,null,23007477.833333332,15928773.25,23007978.5,null,31,29844.583333333332,30140.5,30345.25,30641.166666666668,30845.916666666668,null,23007477.833333332,15928773.25,23007978.5,15929273.916666666,null,31,239027,119108,358135,2942,4978,7920,9956,null,2370,4010,6380,8020,null,3551,6008,9559,12016,null,358135,361686,364143,367694,370151,null,239027,119108.11020800001,358135,null,3551,6008,9559,12016,null,358135,361686,364143,367694,370151,null,31,186.14085239085239,187.98648648648648,189.26351351351352,191.10914760914761,192.38617463617464,null,31,279.21127858627858,281.97972972972974,283.89527027027026,286.66372141372142,288.57926195426194,null,31,93.070426195426194,93.993243243243242,94.631756756756758,95.554573804573806,96.193087318087322]
[32,30350.25,30626.166666666668,30817.083333333332,31093.166666666668,31284.166666666668,null,21455003.5,14855114.416666666,21468411.833333332,null,32,30350.25,30626.166666666668,30817.083333333332,31093.166666666668,31284.166666666668,null,21455003.5,14855114.416666666,21468411.833333332,14862052.166666666,null,32,243077,121126,364203,2743,4642,7387,9286,null,2210,3739,5950,7480,null,3311,5602,8915,11207,null,364203,367514,369805,373118,375410,null,243077,121126.24140800002,364203,null,3311,5602,8915,11207,null,364203,367514,369805,373118,375410,null,32,189.29469854469855,191.01559251559252,192.20634095634097,193.92827442827442,195.11954261954261,null,32,283.94204781704781,286.52338877338877,288.30951143451148,290.89241164241162,292.67931392931393,null,32,94.647349272349274,95.507796257796258,96.103170478170483,96.96413721413721,97.559771309771307]
[33,30866.916666666668,31121.75,31298.166666666668,31553,31729.333333333332,null,19818420.416666668,13729699.5,19818851.666666668,null,33,30866.916666666668,31121.75,31298.166666666668,31553,31729.333333333332,null,19818420.416666668,13729699.5,19818851.666666668,13723660,null,33,247215,{"$f":"ROUND(Y38*regulering,0)","v":123188},370403,2534,4288,6822,8575,null,2041,3454,5495,6907,null,3058,5175,8233,10349,null,370403,373461,375578,378636,380752,null,247215,{"$f":"AW38*regulering","v":123188.22336000002},370403,null,{"$f":"ROUND(AL38*udbygningspct,0)","v":3058},{"$f":"ROUND(AM38*udbygningspct,0)","v":5175},{"$f":"ROUND(AN38*udbygningspct,0)","v":8233},{"$f":"ROUND(AO38*udbygningspct,0)","v":10349},null,370403,373461,375578,378636,380752,null,33,192.51715176715177,194.10654885654887,195.20686070686071,196.79625779625781,197.8960498960499,null,33,288.77572765072767,291.15982328482329,292.81029106029109,295.19438669438671,296.84407484407484,null,33,96.258575883575887,97.053274428274435,97.603430353430355,98.398128898128903,98.948024948024951]
[34,31395.583333333332,31628.083333333332,31788.916666666668,32021.333333333332,32182.333333333332,null,18084788.083333332,12520175.583333334,18078710.666666668,null,34,31395.583333333332,31628.083333333332,31788.916666666668,32021.333333333332,32182.333333333332,null,18084788.083333332,12520175.583333334,18078710.666666668,12533510.333333334,null,34,251449,125298,376747,2311,3911,6222,7823,null,1862,3150,5012,6301,null,2790,4720,7509,9441,null,376747,379537,381467,384256,386188,null,251449,125298.04249600002,376747,null,2790,4720,7509,9441,null,376747,379537,381467,384256,386188,null,34,195.81444906444906,197.264553014553,198.26767151767152,199.71725571725571,200.72141372141371,null,34,293.72167359667361,295.89682952182949,297.40150727650729,299.57588357588355,301.08212058212058,null,34,97.907224532224532,98.632276507276501,99.133835758835758,99.858627858627855,100.36070686070686]
[35,31935.333333333332,32144.083333333332,32288.583333333332,32497.166666666668,32641.75,null,16241164.083333334,11252424.583333334,16228575.833333334,null,35,31935.333333333332,32144.083333333332,32288.583333333332,32497.166666666668,32641.75,null,16241164.083333334,11252424.583333334,16228575.833333334,11259248.416666666,null,35,255772,127452,383224,2076,3512,5586,7024,null,1672,2829,4500,5658,null,2505,4239,6742,8477,null,383224,385729,387463,389966,391701,null,255772,127452.21068800002,383224,null,2505,4239,6742,8477,null,383224,385729,387463,389966,391701,null,35,199.18087318087319,200.48284823284823,201.38409563409564,202.68503118503119,203.58679833679832,null,35,298.7713097713098,300.72427234927233,302.07614345114348,304.02754677754677,305.38019750519749,null,35,99.590436590436596,100.24142411642411,100.69204781704782,101.3425155925156,101.79339916839916]
[36,32487.5,32671.166666666668,32798.166666666664,32981.666666666664,33108.833333333336,null,14294020.5,9894094.166666666,14281389.666666666,null,36,32487.5,32671.166666666668,32798.166666666664,32981.666666666664,33108.833333333336,null,14294020.5,9894094.166666666,14281389.666666666,9907346.166666666,null,36,260194,129656,389850,1826,3089,4914,6177,null,1471,2488,3958,4976,null,2204,3728,5930,7456,null,389850,392054,393578,395780,397306,null,260194,129655.71097600002,389850,null,2204,3728,5930,7456,null,389850,392054,393578,395780,397306,null,36,202.62474012474013,203.77027027027026,204.56237006237006,205.70686070686071,206.5,null,36,303.93711018711019,305.65540540540542,306.8435550935551,308.56029106029109,309.75,null,36,101.31237006237006,101.88513513513513,102.28118503118503,102.85343035343035,103.25]
[37,33051.583333333336,33208.5,33317.25,33474.25,33582.833333333336,null,12217473.833333334,8477537.25,12224210.25,null,37,33051.583333333336,33208.5,33317.25,33474.25,33582.833333333336,null,12217473.833333334,8477537.25,12224210.25,8464861.5,null,37,264712,131907,396619,1560,2642,4202,5282,null,1257,2128,3385,4255,null,1883,3188,5072,6375,null,396619,398502,399807,401691,402994,null,264712,131907.04844800002,396619,null,1883,3188,5072,6375,null,396619,398502,399807,401691,402994,null,37,206.14293139293139,207.12162162162161,207.79989604989606,208.77910602910603,209.45634095634097,null,37,309.2143970893971,310.68243243243239,311.69984407484412,313.16865904365903,314.18451143451148,null,37,103.07146569646569,103.56081081081081,103.89994802494803,104.38955301455302,104.72817047817048]
[38,33650.416666666664,33781.75,33872.75,34004.166666666664,34095.25,null,10231552.416666666,7099840.75,10238245.5,null,38,33650.416666666664,33781.75,33872.75,34004.166666666664,34095.25,null,10231552.416666666,7099840.75,10238245.5,7106533.916666667,null,38,269508,134297,403805,1306,2211,3517,4423,null,1052,1781,2833,3563,null,1576,2668,4245,5338,null,403805,405381,406473,408050,409143,null,269508,134296.91443200002,403805,null,1576,2668,4245,5338,null,403805,405381,406473,408050,409143,null,38,209.87785862785861,210.69698544698545,211.264553014553,212.08419958419958,212.6522869022869,null,38,314.81678794178794,316.04547817047819,316.89682952182949,318.12629937629936,318.97843035343033,null,38,104.93892931392931,105.34849272349273,105.6322765072765,106.04209979209979,106.32614345114345]
[39,34251.583333333336,34352.75,34422.75,34523.916666666664,34594.083333333336,null,7889742.083333333,5469782.75,7889913.25,null,39,34251.583333333336,34352.75,34422.75,34523.916666666664,34594.083333333336,null,7889742.083333333,5469782.75,7889913.25,5482895.416666667,null,39,274323,136696,411019,1006,1702,2708,3405,null,810,1371,2181,2743,null,1214,2054,3268,4110,null,411019,412233,413073,414287,415129,null,274323,136696.24819200003,411019,null,1214,2054,3268,4110,null,411019,412233,413073,414287,415129,null,39,213.62733887733887,214.258316008316,214.69490644490645,215.32588357588358,215.76351351351352,null,39,320.44100831600832,321.387474012474,322.04235966735968,322.98882536382536,323.64527027027026,null,39,106.81366943866944,107.129158004158,107.34745322245323,107.66294178794179,107.88175675675676]
[40,34866.416666666664,34935.583333333336,34983.5,35052.833333333336,35100.75,null,5405588.916666667,3755616.8333333335,5418647.5,null,40,34866.416666666664,34935.583333333336,34983.5,35052.833333333336,35100.75,null,5405588.916666667,3755616.8333333335,5418647.5,3755734.0833333335,null,40,279247,139150,418397,688,1165,1853,2330,null,554,938,1493,1877,null,830,1405,2237,2812,null,418397,419227,419802,420634,421209,null,279247,139149.89708800003,418397,null,830,1405,2237,2812,null,{"$f":"AY45","v":418397},419227,419802,420634,421209,null,40,217.46205821205822,217.89345114345113,218.19230769230768,218.62474012474013,218.92359667359668,null,40,326.19308731808735,326.84017671517671,327.28846153846155,327.93711018711019,328.38539501039503,null,40,108.73102910602911,108.94672557172557,109.09615384615384,109.31237006237006,109.46179833679834]
[41,35494.583333333336,35530.083333333336,35554.75,35590.083333333336,35614.833333333336,null,2792034.0833333335,1950872.0833333333,2779152.75,null,41,35494.583333333336,35530.083333333336,35554.75,35590.083333333336,35614.833333333336,null,2792034.0833333335,1950872.0833333333,2779152.75,1957402.8333333333,null,41,284278,141657,425935,353,598,950,1195,null,284,482,765,963,null,{"$f":"ROUND(VLOOKUP($X46,$X:$AJ,(4+AL$4)+$AM$5)*(1+$AL$5),0)","v":426},722,1146,1443,null,425935,426361,426657,427081,427378,null,284278,141656.86451200003,425935,null,426,722,1146,1443,null,{"$f":"AY46","v":425935},426361,426657,427081,427378,null,41,221.37993762993764,221.60135135135135,221.75519750519751,221.97557172557171,222.12993762993764,null,41,332.06990644490645,332.40202702702703,332.63279625779626,332.96335758835755,333.19490644490645,null,41,110.68996881496882,110.80067567567568,110.87759875259876,110.98778586278586,111.06496881496882]
[42,36136.333333333336,36136.333333333336,36136.333333333336,36136.333333333336,36136.333333333336,null,36136.333333333336,36136.333333333336,36136.333333333336,null,42,36136.333333333336,36136.333333333336,36136.333333333336,36136.333333333336,36136.333333333336,null,36136.333333333336,36136.333333333336,36136.333333333336,36136.333333333336,null,42,289418,144218,433636,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,433636,433636,433636,433636,433636,null,289418,144218.14707200002,433636,null,0,0,0,0,null,433636,433636,433636,433636,433636,null,42,225.38253638253639,225.38253638253639,225.38253638253639,225.38253638253639,225.38253638253639,null,42,338.07380457380458,338.07380457380458,338.07380457380458,338.07380457380458,338.07380457380458,null,42,112.69126819126819,112.69126819126819,112.69126819126819,112.69126819126819,112.69126819126819]
[43,36939.416666666664,36939.416666666664,36939.416666666664,36939.416666666664,36939.416666666664,null,36939.416666666664,36939.416666666664,36939.416666666664,null,43,36939.416666666664,36939.416666666664,36939.416666666664,36939.416666666664,36939.416666666664,null,36939.416666666664,36939.416666666664,36939.416666666664,36939.416666666664,null,43,295850,147423,443273,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,443273,443273,443273,443273,443273,null,295850,147423.23840000003,443273,null,0,0,0,0,null,443273,443273,443273,443273,443273,null,43,230.39137214137213,230.39137214137213,230.39137214137213,230.39137214137213,230.39137214137213,null,43,345.5870582120582,345.5870582120582,345.5870582120582,345.5870582120582,345.5870582120582,null,43,115.19568607068607,115.19568607068607,115.19568607068607,115.19568607068607,115.19568607068607]
[44,37764.75,37764.75,37764.75,37764.75,37764.75,null,37764.75,37764.75,37764.75,null,44,37764.75,37764.75,37764.75,37764.75,37764.75,null,37764.75,37764.75,37764.75,37764.75,null,44,302460,150717,453177,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,453177,453177,453177,453177,453177,null,302460,150717.02784000002,453177,null,0,0,0,0,null,453177,453177,453177,453177,453177,null,44,235.53898128898129,235.53898128898129,235.53898128898129,235.53898128898129,235.53898128898129,null,44,353.30847193347194,353.30847193347194,353.30847193347194,353.30847193347194,353.30847193347194,null,44,117.76949064449065,117.76949064449065,117.76949064449065,117.76949064449065,117.76949064449065]
[45,38612.666666666664,38612.666666666664,38612.666666666664,38612.666666666664,38612.666666666664,null,38612.666666666664,38612.666666666664,38612.666666666664,null,45,38612.666666666664,38612.666666666664,38612.666666666664,38612.666666666664,38612.666666666664,null,38612.666666666664,38612.666666666664,38612.666666666664,38612.666666666664,null,45,309251,154101,463352,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,463352,463352,463352,463352,463352,null,309251,154101.01030400002,463352,null,0,0,0,0,null,463352,463352,463352,463352,463352,null,45,240.82744282744284,240.82744282744284,240.82744282744284,240.82744282744284,240.82744282744284,null,45,361.24116424116426,361.24116424116426,361.24116424116426,361.24116424116426,361.24116424116426,null,45,120.41372141372142,120.41372141372142,120.41372141372142,120.41372141372142,120.41372141372142]
[46,39483.916666666664,39483.916666666664,39483.916666666664,39483.916666666664,39483.916666666664,null,39483.916666666664,39483.916666666664,39483.916666666664,null,46,39483.916666666664,39483.916666666664,39483.916666666664,39483.916666666664,39483.916666666664,null,39483.916666666664,39483.916666666664,39483.916666666664,39483.916666666664,null,46,316229,157578,473807,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,473807,473807,473807,473807,473807,null,316229,157578.17561600002,473807,null,0,0,0,0,null,473807,473807,473807,473807,473807,null,46,246.26143451143452,246.26143451143452,246.26143451143452,246.26143451143452,246.26143451143452,null,46,369.39215176715174,369.39215176715174,369.39215176715174,369.39215176715174,369.39215176715174,null,46,123.13071725571726,123.13071725571726,123.13071725571726,123.13071725571726,123.13071725571726]
[47,40186.75,40186.75,40186.75,40186.75,40186.75,null,40186.75,40186.75,40186.75,null,47,40186.75,40186.75,40186.75,40186.75,40186.75,null,40186.75,40186.75,40186.75,40186.75,null,47,321858,160383,482241,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,482241,482241,482241,482241,482241,null,321858,160383.12883200002,482241,null,0,0,0,0,null,482241,482241,482241,482241,482241,null,47,250.64501039501039,250.64501039501039,250.64501039501039,250.64501039501039,250.64501039501039,null,47,375.96751559251561,375.96751559251561,375.96751559251561,375.96751559251561,375.96751559251561,null,47,125.32250519750519,125.32250519750519,125.32250519750519,125.32250519750519,125.32250519750519]
[48,42034.083333333336,42034.083333333336,42034.083333333336,42034.083333333336,42034.083333333336,null,42034.083333333336,42034.083333333336,42034.083333333336,null,48,42034.083333333336,42034.083333333336,42034.083333333336,42034.083333333336,42034.083333333336,null,42034.083333333336,42034.083333333336,42034.083333333336,42034.083333333336,null,48,336653,167756,504409,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,504409,504409,504409,504409,504409,null,336653,167755.53651200002,504409,null,0,0,0,0,null,504409,504409,504409,504409,504409,null,48,262.16683991683993,262.16683991683993,262.16683991683993,262.16683991683993,262.16683991683993,null,48,393.25025987525987,393.25025987525987,393.25025987525987,393.25025987525987,393.25025987525987,null,48,131.08341995841997,131.08341995841997,131.08341995841997,131.08341995841997,131.08341995841997]
[49,44855,44855,44855,44855,44855,null,44855,44855,44855,null,49,{"$f":"BF54/12","v":44855},44855,44855,44855,44855,null,44855,44855,44855,44855,null,49,359246,179014,538260,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,538260,538260,538260,538260,538260,null,359246,179013.71878400003,538260,null,0,0,0,0,null,538260,538260,538260,538260,538260,null,49,279.76091476091477,279.76091476091477,279.76091476091477,279.76091476091477,279.76091476091477,null,49,419.64137214137213,419.64137214137213,419.64137214137213,419.64137214137213,419.64137214137213,null,49,139.88045738045739,139.88045738045739,139.88045738045739,139.88045738045739,139.88045738045739]
[50,47986.166666666664,47986.166666666664,47986.166666666664,47986.166666666664,47986.166666666664,null,47986.166666666664,47986.166666666664,47986.166666666664,null,50,{"$f":"BF55/12","v":49118},49118,49118,49118,49118,null,49118,49118,49118,49118,null,50,384324,191510,575834,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,575834,575834,575834,575834,575834,null,393389,196027.31225600003,589416,null,0,0,0,0,null,589416,589416,589416,589416,589416,null,50,299.29002079002078,299.29002079002078,299.29002079002078,299.29002079002078,299.29002079002078,null,50,448.93503118503116,448.93503118503116,448.93503118503116,448.93503118503116,448.93503118503116,null,50,149.64501039501039,149.64501039501039,149.64501039501039,149.64501039501039,149.64501039501039]
[51,53004.25,53004.25,53004.25,53004.25,53004.25,null,53004.25,53004.25,53004.25,null,51,54431,54431,54431,54431,54431,null,54431,54431,54431,54431,null,51,424514,211537,636051,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,636051,636051,636051,636051,636051,null,435941,217231.14406400002,653172,null,0,0,0,0,null,653172,653172,653172,653172,653172,null,51,330.58783783783781,330.58783783783781,330.58783783783781,330.58783783783781,330.58783783783781,null,51,495.88175675675672,495.88175675675672,495.88175675675672,495.88175675675672,495.88175675675672,null,51,165.29391891891891,165.29391891891891,165.29391891891891,165.29391891891891,165.29391891891891]
[52,60312.25,60312.25,60312.25,60312.25,60312.25,null,60312.25,60312.25,60312.25,null,52,61991.166666666664,61991.166666666664,61991.166666666664,61991.166666666664,61991.166666666664,null,61991.166666666664,61991.166666666664,61991.166666666664,61991.166666666664,null,52,483044,240703,723747,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,723747,723747,723747,723747,723747,null,496491,247403.45126400003,743894,null,0,0,0,0,null,743894,743894,743894,743894,743894,null,52,376.16787941787942,376.16787941787942,376.16787941787942,376.16787941787942,376.16787941787942,null,52,564.2518191268191,564.2518191268191,564.2518191268191,564.2518191268191,564.2518191268191,null,52,188.08393970893971,188.08393970893971,188.08393970893971,188.08393970893971,188.08393970893971]
[53,66220.583333333328,66220.583333333328,66220.583333333328,66220.583333333328,66220.583333333328,null,66220.583333333328,66220.583333333328,66220.583333333328,null,53,69006.5,69006.5,69006.5,69006.5,69006.5,null,69006.5,69006.5,69006.5,69006.5,null,53,530364,264283,794647,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,794647,794647,794647,794647,794647,null,552677,275401.15980800003,828078,null,0,0,0,0,null,828078,828078,828078,828078,828078,null,53,413.01819126819129,413.01819126819129,413.01819126819129,413.01819126819129,413.01819126819129,null,53,619.52728690228696,619.52728690228696,619.52728690228696,619.52728690228696,619.52728690228696,null,53,206.50909563409564,206.50909563409564,206.50909563409564,206.50909563409564,206.50909563409564]
[54,74097.25,74097.25,74097.25,74097.25,74097.25,null,74097.25,74097.25,74097.25,null,54,77750,77750,77750,77750,77750,null,77750,77750,77750,77750,null,54,593449,295718,889167,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,889167,889167,889167,889167,889167,null,622704,310295.89401600003,933000,null,0,0,0,0,null,933000,933000,933000,933000,933000,null,54,462.14501039501039,462.14501039501039,462.14501039501039,462.14501039501039,462.14501039501039,null,54,693.21751559251561,693.21751559251561,693.21751559251561,693.21751559251561,693.21751559251561,null,54,231.07250519750519,231.07250519750519,231.07250519750519,231.07250519750519,231.07250519750519]
[55,83565.166666666672,83565.166666666672,83565.166666666672,83565.166666666672,83565.166666666672,null,83565.166666666672,83565.166666666672,83565.166666666672,null,55,87217.916666666672,87217.916666666672,87217.916666666672,87217.916666666672,87217.916666666672,null,87217.916666666672,87217.916666666672,87217.916666666672,87217.916666666672,null,55,669278,333504,1002782,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,1002782,1002782,1002782,1002782,1002782,null,698533,348081.78803200007,1046615,null,0,0,0,0,null,1046615,1046615,1046615,1046615,1046615,null,55,521.19646569646568,521.19646569646568,521.19646569646568,521.19646569646568,521.19646569646568,null,55,781.79469854469858,781.79469854469858,781.79469854469858,781.79469854469858,781.79469854469858,null,55,260.59823284823284,260.59823284823284,260.59823284823284,260.59823284823284,260.59823284823284]
[56,94182,94182,94182,94182,94182,null,94182,94182,94182,null,56,97835,97835,97835,97835,97835,null,97835,97835,97835,97835,null,56,754309,375875,1130184,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,1130184,1130184,1130184,1130184,1130184,null,783566,390454.07206400007,1174020,null,0,0,0,0,null,1174020,1174020,1174020,1174020,1174020,null,56,587.41372141372142,587.41372141372142,587.41372141372142,587.41372141372142,587.41372141372142,null,56,881.12058212058218,881.12058212058218,881.12058212058218,881.12058212058218,881.12058212058218,null,56,293.70686070686071,293.70686070686071,293.70686070686071,293.70686070686071,293.70686070686071]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Y62*valgt_regulering,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["2006-10-01",4131.67,4204.9799999999996,4265.26,4358.1099999999997,4420,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["2007-04-01",4229.54,4303.8900000000003,4365.01,4459.17,4521.93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Forside","index":3,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,3,14,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Lønniveau:","2023-04-01"]
[]
[]
[]
[null,null,null,"Hvad betyder det for lønnen, hvis man ændrer på lønsammensætning eller timetal ?"]

{"sheet":"Omregner","index":4,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Valgt lønniveau:",null,{"$f":"Forside!K11","v":"2023-04-01"},null,"Timetal:",37]
[]
[null,"1) Grundbeløb pr. 31-3-2000 omregnet til nutidskr. "]
[null,null,"Årligt grundbeløb:",null,11300]
[]
[null,null,null,null,"år","måned"]
[null,null,"Aktuelt beløb",null,{"$f":"ROUND(((kr_omregnes*valgt_regulering)/37*I11),0)","v":16931},{"$f":"E17/12","v":1410.9166666666667}]
[]
[]
[null,"2) Beløb der skal omregnes til '31-3-2000-niveau'"]
[null,null,"Månedligt beløb",null,1296.9000000000001]
[]
[null,null,null,null,"år","måned"]
[null,null,"Grundbeløb pr. 31-3-2000",null,{"$f":"ROUND(E21*12/valgt_regulering,0)/I11*37","v":10387},{"$f":"E24/12","v":865.58333333333337}]

{"sheet":"Omregningstabel ","index":5,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[null,null,null,1.362716,1.3824959999999999,1.3980790000000001,1.018559,1.040662,1.0511569999999999,1.061566,1.0834220000000001,1.0886800000000001,1.0926750000000001,1.109523,1.1200380000000001,1.1244540000000001]
[]
[]
[]
[]
[]
[null,"Indtast beløb:",1000]
[]
[]
[null,null,"1/10 '84"]
[null,null,{"$f":"Beløb","v":1000},"1/4 '98"]
[null,"1/4-98",{"$f":"Beløb*_1_4_1998","v":1362.7160000000001},{"$f":"Beløb","v":1000},"1/10 '98"]
[null,"1/10-98",{"$f":"Beløb*_1_10_1998","v":1382.4959999999999},{"$f":"Beløb/_1_4_1998*_1_10_1998","v":1014.515130078461},{"$f":"Beløb","v":1000},"1/4 '99"]
[null,"1/4-99",{"$f":"Beløb*_1_4_1999","v":1398.0790000000002},{"$f":"Beløb/_1_4_1998*_1_4_1999","v":1025.9503814441161},{"$f":"Beløb/_1_10_1998*_1_4_1999","v":1011.2716420156008},{"$f":"Beløb","v":1000}]
[null,"Grundbeløb pr. 31/3-00",{"$f":"ROUND(C14,-2)","v":1400},{"$f":"ROUND(D14,-2)","v":1000},{"$f":"ROUND(E14,-2)","v":1000},{"$f":"ROUND(F14,-2)","v":1000},"1/4 '00"]
[null,"1/4-00",{"$f":"Nyt_beløb_1*_1_4_2000","v":1425.9826},{"$f":"Nyt_beløb_2*_1_4_2000","v":1018.559},{"$f":"Nyt_beløb_3*_1_4_2000","v":1018.559},{"$f":"Nyt_beløb_4*_1_4_2000","v":1018.559},{"$f":"Beløb","v":1000},"1/4 '01"]
[null,"1/4-01",{"$f":"Nyt_beløb_1*_1_4_2001","v":1456.9268},{"$f":"Nyt_beløb_2*_1_4_2001","v":1040.662},{"$f":"Nyt_beløb_3*_1_4_2001","v":1040.662},{"$f":"Nyt_beløb_4*_1_4_2001","v":1040.662},{"$f":"beløb_4_00/_1_4_2000*_1_4_2001","v":1021.7002647858396},{"$f":"Beløb","v":1000},"1/10 '01"]
[null,"1/10-01",{"$f":"Nyt_beløb_1*_1_10_2001","v":1471.6197999999999},{"$f":"Nyt_beløb_2*_1_10_2001","v":1051.1569999999999},{"$f":"Nyt_beløb_3*_1_10_2001","v":1051.1569999999999},{"$f":"Nyt_beløb_4*_1_10_2001","v":1051.1569999999999},{"$f":"beløb_4_00/_1_4_2000*_1_10_2001","v":1032.0040370759082},{"$f":"beløb_4_01/_1_4_2001*_1_10_2001","v":1010.0849267101133},{"$f":"Beløb","v":1000},"1/4 '02"]
[null,"1/4-02",{"$f":"Nyt_beløb_1*_1_4_2002","v":1486.1923999999999},{"$f":"Nyt_beløb_2*_1_4_2002","v":1061.566},{"$f":"Nyt_beløb_3*_1_4_2002","v":1061.566},{"$f":"Nyt_beløb_4*_1_4_2002","v":1061.566},{"$f":"beløb_4_00/_1_4_2000*_1_4_2002","v":1042.2233763581687},{"$f":"beløb_4_01/_1_4_2001*_1_4_2002","v":1020.0872137158848},{"$f":"beløb_10_01/_1_10_2001*_1_4_2002","v":1009.9024218075892},{"$f":"Beløb","v":1000},"1/4 '03"]
[null,"1/4-03",{"$f":"Nyt_beløb_1*_1_4_2003","v":1516.7908000000002},{"$f":"Nyt_beløb_2*_1_4_2003","v":1083.422},{"$f":"Nyt_beløb_3*_1_4_2003","v":1083.422},{"$f":"Nyt_beløb_4*_1_4_2003","v":1083.422},{"$f":"beløb_4_00/_1_4_2000*_1_4_2003","v":1063.6811416913504},{"$f":"beløb_4_01/_1_4_2001*_1_4_2003","v":1041.0892297403002},{"$f":"beløb_10_01/_1_10_2001*_1_4_2003","v":1030.6947487387708},{"$f":"beløb_4_02/_1_4_2002*_1_4_2003","v":1020.5884514010435},{"$f":"Beløb","v":1000},"1/8 '03"]
[null,"1/8-03",{"$f":"Nyt_beløb_1*_1_8_2003","v":1524.152},{"$f":"Nyt_beløb_2*_1_8_2003","v":1088.68},{"$f":"Nyt_beløb_3*_1_8_2003","v":1088.68},{"$f":"Nyt_beløb_4*_1_8_2003","v":1088.68},{"$f":"beløb_4_00/_1_4_2000*_1_8_2003","v":1068.8433365175706},{"$f":"beløb_4_01/_1_4_2001*_1_8_2003","v":1046.1417828267008},{"$f":"beløb_10_01/_1_10_2001*_1_8_2003","v":1035.6968559406446},{"$f":"beløb_4_02/_1_4_2002*_1_8_2003","v":1025.5415113144168},{"$f":"beløb_4_03/_1_4_2003*_1_8_2003","v":1004.853141250593},{"$f":"Beløb","v":1000},"1/10 '03"]
[null,"1/10-03",{"$f":"Nyt_beløb_1*_1_10_2003","v":1529.7450000000001},{"$f":"Nyt_beløb_2*_1_10_2003","v":1092.675},{"$f":"Nyt_beløb_3*_1_10_2003","v":1092.675},{"$f":"Nyt_beløb_4*_1_10_2003","v":1092.675},{"$f":"beløb_4_00/_1_4_2000*_1_10_2003","v":1072.7655442640043},{"$f":"beløb_4_01/_1_4_2001*_1_10_2003","v":1049.9806853714272},{"$f":"beløb_4_01/_1_4_2001*_1_10_2003","v":1049.9806853714272},{"$f":"beløb_4_02/_1_4_2002*_1_10_2003","v":1029.3048194836686},{"$f":"beløb_4_03/_1_4_2003*_1_10_2003","v":1008.5405317595545},{"$f":"beløb_8_03/_1_8_2003*_1_10_2003","v":1003.6695815115553},{"$f":"Beløb","v":1000},"1/4 '04"]
[null,"1/4 '04",{"$f":"Nyt_beløb_1*_1_4_2004","v":1553.3322000000001},{"$f":"Nyt_beløb_2*_1_4_2004","v":1109.5230000000001},{"$f":"Nyt_beløb_3*_1_4_2004","v":1109.5230000000001},{"$f":"Nyt_beløb_4*_1_4_2004","v":1109.5230000000001},{"$f":"beløb_4_00/_1_4_2000*_1_4_2004","v":1089.3065595611056},{"$f":"beløb_4_01/_1_4_2001*_1_4_2004","v":1066.1703800081104},{"$f":"beløb_4_01/_1_4_2001*_1_4_2004","v":1066.1703800081104},{"$f":"beløb_4_02/_1_4_2002*_1_4_2004","v":1045.1757121083381},{"$f":"beløb_4_03/_1_4_2003*_1_4_2004","v":1024.091258992341},{"$f":"beløb_8_03/_1_8_2003*_1_4_2004","v":1019.1452033655436},{"$f":"beløb_10_03/_1_10_2003*_1_4_2004","v":1015.4190404283066},{"$f":"Beløb","v":1000},"1/8 '04"]
[null,"1/8 '04",{"$f":"Nyt_beløb_1*_1_8_2004","v":1568.0532000000001},{"$f":"Nyt_beløb_2*_1_8_2004","v":1120.038},{"$f":"Nyt_beløb_3*_1_8_2004","v":1120.038},{"$f":"Nyt_beløb_4*_1_8_2004","v":1120.038},{"$f":"beløb_4_00/_1_4_2000*_1_8_2004","v":1099.6299674343854},{"$f":"beløb_4_01/_1_4_2001*_1_8_2004","v":1076.2745252541172},{"$f":"beløb_4_01/_1_4_2001*_1_8_2004","v":1076.2745252541172},{"$f":"beløb_4_02/_1_4_2002*_1_8_2004","v":1055.0808899305366},{"$f":"beløb_4_03/_1_4_2003*_1_8_2004","v":1033.7966184921481},{"$f":"beløb_8_03/_1_8_2003*_1_8_2004","v":1028.8036888709262},{"$f":"beløb_10_03/_1_10_2003*_1_8_2004","v":1025.0422129178392},{"$f":"beløb_4_04/_1_4_2004*_1_8_2004","v":1009.4770455411921},{"$f":"Beløb","v":1000},"1/10 '04"]
[null,"1/10 '04",{"$f":"Nyt_beløb_1*_1_10_2004","v":1574.2356},{"$f":"Nyt_beløb_2*_1_10_2004","v":1124.4540000000002},{"$f":"Nyt_beløb_3*_1_10_2004","v":1124.4540000000002},{"$f":"Nyt_beløb_4*_1_10_2004","v":1124.4540000000002},{"$f":"beløb_4_00/_1_4_2000*_1_10_2004","v":1103.9655042074146},{"$f":"beløb_4_01/_1_4_2001*_1_10_2004","v":1080.5179779794016},{"$f":"beløb_4_01/_1_4_2001*_1_10_2004","v":1080.5179779794016},{"$f":"beløb_4_02/_1_4_2002*_1_10_2004","v":1059.2407820144956},{"$f":"beløb_4_03/_1_4_2003*_1_10_2004","v":1037.8725925816534},{"$f":"beløb_8_03/_1_8_2003*_1_10_2004","v":1032.8599772201198},{"$f":"beløb_10_03/_1_10_2003*_1_10_2004","v":1029.0836708078798},{"$f":"beløb_4_04/_1_4_2004*_1_10_2004","v":1013.4571342820293},{"$f":"beløb_8_04/_1_8_2004*_1_10_2004","v":1003.9427233718856},{"$f":"Beløb","v":1000}]

{"sheet":"Tillæg_trin","index":6,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,1,1,7]]}
[3]
[]
[null,"Valgt lønniveau: ",{"$f":"Forside!K11","v":"2023-04-01"}]
[]
[null,"Løngruppe",null,3]
[null,"Timer/uge",null,37]
[null,"Pensions-% inkl. evt. fritvalgs-%",null,13.89]
[null,"Særlig feriegodtgørelse, aktuel pct.",null,1.95]
[]
[null,"Stigning:","Fra","Til"]
[null,"Løntrin ",18,19]
[]
[null,"Løn",{"$f":"(VLOOKUP(til_trin,Lønark!A5:F61,løngruppe+2,FALSE)-VLOOKUP(fra_trin,Lønark!A5:F61,løngruppe+2,FALSE))/37*timetal*12","v":4263}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"(VLOOKUP(til_trin,Lønark!L5:Q61,løngruppe+2,FALSE)-VLOOKUP(fra_trin,Lønark!L5:Q61,løngruppe+2,FALSE))/37*timetal*pensionsstatus%*12","v":592.13070000000005}]
[null,"Ferietillæg",{"$f":"ferie_pct%*C13","v":83.128500000000003}]
[null,"Årlig bruttoudgift i alt",{"$f":"ROUND(SUM(C13:C15),0)","v":4938}]

{"sheet":"Tillæg_kr","index":7,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":true,"merged":[[9,1,9,2]]}
[2]
[]
[null,null,"Valgt lønniveau:",{"$f":"Forside!K11","v":"2023-04-01"}]
[]
[{"$f":"VLOOKUP(dummy,reg_procenter,2,FALSE)","v":{"$error":"#NAME?"}},null,"Årligt beløb, 31.3.2000 niveau ",12900]
[null,null,"Timer/uge",30]
[null,null,"Pension-% inkl. evt. fritvalgs-%",13.89]
[null,null,"Særlig feriegodtg., aktuel pct.",1.95]
[]
[]
[null,null,"bruttoudgift / år","bruttoudgift / md"]
[null,"Løn",{"$f":"kr*valgt_regulering/37*timetal","v":15671.449945945948},{"$f":"beløb/12","v":1305.9541621621622}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"beløb*pensionsstatus%","v":2176.7643974918919},{"$f":"C13/12","v":181.39703312432434}]
[null,"Ferietillæg",{"$f":"D8%*(C12)","v":305.59327394594595},{"$f":"C14/12","v":25.466106162162163}]
[null,"Bruttoudgift i alt",{"$f":"ROUND(SUM(C12:C14),0)","v":18154},{"$f":"ROUND(SUM(D12:D14),0)","v":1513}]

{"sheet":"Samlet_omk","index":8,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[2,"Valgt lønniveau: ",{"$f":"Forside!K11","v":"2023-04-01"}]
[]
[null,"Løngruppe",0]
[null,"Timer/uge",37]
[null,"Pensions-% inkl. evt. fritvalgs-%",13.89]
[null,"Særlig feriegodtgørelse, aktuel pct.",1.95]
[]
[null,"Løntrin ",21]
[]
[null,"Reguleret tillæg (31.3.2000) kr./år",12000]
[]
[]
[null,"Løn/time",{"$f":"IFERROR(ROUND(VLOOKUP(fra_trin,Lønark!A5:AU61,løngruppe+43,FALSE)/1924,2)+ROUND(C10*valgt_regulering/1924,2),ROUND(C10*valgt_regulering/1924,2))","v":168.16}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"C13*pensionsstatus%","v":23.357423999999998}]
[null,"Ferietillæg",{"$f":"C6%*C13","v":3.2791199999999998}]
[null,"Time bruttoudgift i alt",{"$f":"SUM(C13:C15)","v":194.79654400000001}]
[]
[null,"Løn/måned",{"$f":"IFERROR((VLOOKUP(fra_trin,Lønark!A5:F61,løngruppe+2,FALSE)+(C10*valgt_regulering/12))/37*timetal,C10*valgt_regulering/12/37*timetal)","v":26961.887333333332}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"IFERROR(((VLOOKUP(fra_trin,Lønark!L5:Q61,løngruppe+2,FALSE)+C10/12*valgt_regulering)/37*timetal)*pensionsstatus%,C10/12*valgt_regulering/37*timetal*pensionsstatus%)","v":3745.0061505999997}]
[null,"Ferietillæg",{"$f":"C6%*C18","v":525.75680299999999}]
[null,"Månedlig bruttoudgift i alt",{"$f":"SUM(C18:C20)","v":31232.650286933331}]
[]
[null,"Løn/år",{"$f":"C18*12","v":323542.64799999999}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"C19*12","v":44940.073807199995}]
[null,"Ferietillæg",{"$f":"C20*12","v":6309.0816359999999}]
[null,"Årlig bruttoudgift i alt",{"$f":"SUM(C23:C25)","v":374791.80344320001}]

{"sheet":"Tid op_ned","index":9,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[2,"Valgt lønniveau: ",{"$f":"Forside!K11","v":"2023-04-01"}]
[]
[null,"Grundoplysninger:"]
[null,"Løngruppe",4]
[null,"Pensions-% inkl. evt. fritvalgs-%",12.6]
[null,"Særlig feriegodtgørelse, aktuel procent",1.95]
[]
[]
[null,"Lønsammensætning (trin i alt og grundbeløb i alt)","Før ændring",null,"Efter ændring"]
[]
[null,"Løndele:","I alt"]
[]
[null,"Løntrin - centralt og lokalt aftalte",21,null,21]
[]
[null,"Tillæg (grundbeløb 31.3.2000) kr./år centralt og lokalt aftalte"]
[]
[]
[null,null,"Før ændring",null,"Efter ændring",null,null,"Difference"]
[null,"Timer/uge",37,null,30,null,null,{"$f":"-(C19-timetal_ny)","v":-7}]
[]
[null,"Fast månedsløn",{"$f":"(VLOOKUP(C13,Lønark!A5:F61,$C$4+2,FALSE)+((C15)*valgt_regulering/12))/37*C19","v":26913.416666666668},null,{"$f":"(VLOOKUP(E13,Lønark!A5:F61,$C$4+2,FALSE)+((E15)*valgt_regulering/12))/37*timetal_ny","v":21821.68918918919},null,null,{"$f":"E21-C21","v":-5091.7274774774778}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"(((VLOOKUP(C13,Lønark!L5:Q61,$C$4+2,FALSE)+(C15*valgt_regulering/12))/37*C19)*C5%)","v":3391.0905000000002},null,{"$f":"((VLOOKUP(E13,Lønark!L5:Q61,$C$4+2,FALSE)+(E15*valgt_regulering/12))/37*timetal_ny)*C5%","v":2749.5328378378381},null,null,{"$f":"E22-C22","v":-641.55766216216216}]
[null,"Ferietillæg",{"$f":"$C$6%*C21","v":524.81162500000005},null,{"$f":"$C$6%*E21","v":425.52293918918923},null,null,{"$f":"E23-C23","v":-99.288685810810819}]
[null,"Månedsløn, brutto",{"$f":"SUM(C21:C23)","v":30829.318791666668},null,{"$f":"SUM(E21:E23)","v":24996.744966216214},null,null,{"$f":"E24-C24","v":-5832.573825450454}]
[]
[null,"Fast løn, år",{"$f":"C21*12","v":322961},0,261860.2702702703,null,null,{"$f":"E26-C26","v":-61100.729729729705}]
[null,"Pension inkl. evt. fritvalgstillæg, år",40693.086000000003,0,32994.394054054057,null,null,{"$f":"E27-C27","v":-7698.6919459459459}]
[null,"Ferietillæg, år",{"$f":"C23*12","v":6297.7395000000006},null,{"$f":"E23*12","v":5106.275270270271},null,null,{"$f":"E28-C28","v":-1191.4642297297296}]
[null,"Årsløn, brutto",{"$f":"SUM(C26:C28)","v":369951.82550000004},null,{"$f":"SUM(E26:E28)","v":299960.93959459465},null,null,{"$f":"E29-C29","v":-69990.88590540539}]
[]
[null,"Timeløn",{"$f":"ROUND(VLOOKUP(C13,Lønark!A5:AU61,C4+43,FALSE)/1924,2)+ROUND(C15*valgt_regulering/1924,2)","v":167.86},{"$f":"D26/timetal_ny*37/1924","v":0},{"$f":"ROUND(VLOOKUP(E13,Lønark!A5:AU61,C4+43,FALSE)/1924,2)+ROUND(E15*valgt_regulering/1924,2)","v":167.86},null,null,{"$f":"E31-C31","v":0}]